Forum Discussion
ihartdata
Microsoft Employee
Microsoft EmployeeDATEDIFF 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...
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
thomasronn
Resolver I
Resolver ISwap 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
- ihartdata
Thomas!!! That worked. Thank you, thank you, thank you. I have been racking my brains for way too long. Super appreciated! Have a lovely weekend.
