Datediff function is giving always negative values

[Anonymous]

Hi,

I am using the below expression:

Recv Split = DATEDIFF('Data'[LW_RECEIVE_END_DATE_TIME], 'Data'[LW_RECEIVE_START_DATE_TIME], SECOND)

and my source data is like below:

But I am always getting negative values. Please help me.

[v-yuta-msft · Accepted solution]

@Anonymous ,

Start_Date should be in the first parameter position while End_Date be in the second parameter as below.

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Have you tried flipping the start and end times?

Ex. Recv Split = DATEDIFF('Data'[LW_RECEIVE_START_DATE_TIME],'Data'[LW_RECEIVE_END_DATE_TIME],  SECOND)

This is a really lazy work around but couldn't you multiply the function by -1? If it is always giving you negatives that should work. 

Ex. Recv Split = DATEDIFF('Data'[LW_RECEIVE_START_DATE_TIME],'Data'[LW_RECEIVE_END_DATE_TIME],  SECOND)*-1