How do we tackle this issue... datediff calculate 0 where both dates are same.
DATEDIFF([DATE START], [DATE END], DAY)
Go to Solution.
Your welcome, I mean you can try something like this instead
If (startday=enddate), 1 , DATEDIFF([DATE START], [DATE END], DAY))
View solution in original post
@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.
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
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.