Forum Discussion
Solved
Using IF statement with dates - issues!
I have two dates columns (Request Date and Event Date). I need to calculate the time between each date, to identify how long clients have waited for their event. However, in our data, if an event (...
add a calculated column as:
Column = IF( TableName[Event Date] = DATE(2099,1,1) ,TODAY() - TableName[Request Date] ,TableName[Event Date] - TableName[Request Date] )
This is a great community forum. Much appreciated!