Forum Discussion
Resolver IIDatediff 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
Applicable88Impactful Individual
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.
mohammadyousafThank 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
- Applicable88
Your welcome, I mean you can try something like this instead
If (startday=enddate), 1 , DATEDIFF([DATE START], [DATE END], DAY))