Skip to main content
Solved

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

  • Oct 1, 2019 7:19 AM UTC
  • 0 replies
  • 35 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
------------------------------
View original
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
  • Qrew Champion
  • Answer
  • Oct 1, 2019 7:24 AM UTC
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
------------------------------