Forum Discussion
Solved
Datediff for same dates.
How do we tackle this issue... datediff calculate 0 where both dates are same. Date Start Date End 11 October 2021 11 October 2021 DATEDIFF([DATE START], [DATE END], DAY) Result ...
Your welcome, I mean you can try something like this instead
If (startday=enddate), 1 , DATEDIFF([DATE START], [DATE END], DAY))
Thank you, I guess IF workaround should be ok, let me try it.
In our line of business... it is calculated as working day regardless of working hours.
I am trying to find a way where one day is included in the calculations of two dates... even if dates are apart, I miss the first day as working day
Your welcome, I mean you can try something like this instead
If (startday=enddate), 1 , DATEDIFF([DATE START], [DATE END], DAY))