Datediff for same dates.

[mohammadyousaf]

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"

[Applicable88]

@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. 

[mohammadyousaf]

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

[Applicable88 · Accepted solution]

Your welcome, I mean you can try something like this instead

If (startday=enddate), 1 , DATEDIFF([DATE START], [DATE END], DAY))