Forum Discussion
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 "0"
Your welcome, I mean you can try something like this instead
If (startday=enddate), 1 , DATEDIFF([DATE START], [DATE END], DAY))
3 Replies
mohammadyousaf what value do you expect? Since its the same day there is no difference in value. If you want that same day displayed as one than try:
if (DATEDIFF([DATE START], [DATE END], DAY))= 0, 1, DATEDIFF([DATE START], [DATE END], DAY))
Hope that helps.
Best.
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))
