Forum Discussion

SyaefulBahri3's avatar
SyaefulBahri3
Qrew Trainee
6 years ago

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

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
------------------------------
  • 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
    ------------------------------
  • 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
    ------------------------------
    • SyaefulBahri3's avatar
      SyaefulBahri3
      Qrew Trainee
      Thanks Mark

      It's working, as always

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