Forum Discussion
Datediff for same dates.
Your welcome, I mean you can try something like this instead
If (startday=enddate), 1 , DATEDIFF([DATE START], [DATE END], DAY))
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))