Skip to main content
Solved

[End date] - [Start date] Duration Not Show 0 (Zero) For One Day Event

  • October 1, 2019
  • 0 replies
  • 26 views

Hi All,

just playing with formula duration to count the duration of the event. Unfortunately its show 0 (zero) duration for one day event.

Following formula date duration [End date] - [Start date] if the event have same start date and end date which is one day event is show 0 (day) duration.

It's possible for this case to count one day event as 1 day duration?

Many thanks



------------------------------
Syaeful Bahri
------------------------------

Best answer by MarkShnierYou

Np. Just Add 1Day


End date] - [Start date] + Days(1)

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
Np. Just Add 1Day


End date] - [Start date] + Days(1)

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------