Forum Discussion

ihartdata's avatar
ihartdata
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago
Solved

DATEDIFF with blanks and wonky dates - need help!

Hi,   I am trying to create a calculated column to provide the number of days between an inbound request and an outbound invitation. All of the data needed is now contained in one table. Unfortunat...
Need Help
  • thomasronn's avatar
    thomasronn
    8 years ago

    Swap start and end date in DATEDIFF() when Start Date i greather than End Date.

    Change this part 

    ...-1*DATEDIFF('Table'[Start Date],'Table'[End Date],DAY)...

    to

    ...-1*DATEDIFF('Table'[End Date],'Table'[Start Date],DAY)...

     

    and yes, End Date<Start Date = Start Date>End Date. So you don't need to check both

Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi there

 

The DATEDIFF function will throw and error if it things the first of the two parameters is larger than the second parameter,

 

Are you just after the number of days between each date?

 

If so, covert the dates to INTand then subtract the values.  This will give negative numbers for inverse dates (but no error)

 

CalcColumn = INT('Table'[End Date] - 'Table'[Start Date])