Forum Discussion

Creative_tree88's avatar
Creative_tree88
Icon for Helper V rankHelper V
3 years ago
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 (...
Need Help
  • ChrisMendoza's avatar
    ChrisMendoza
    3 years ago

    Creative_tree88 -

    add a calculated column as:

    Column = 
IF(
    TableName[Event Date] = DATE(2099,1,1)
    ,TODAY() - TableName[Request Date]
    ,TableName[Event Date] - TableName[Request Date]
)

     

ChrisMendoza's avatar
ChrisMendoza
Icon for Resident Rockstar rankResident Rockstar
3 years ago

Creative_tree88 -

add a calculated column as:

Column = 
IF(
    TableName[Event Date] = DATE(2099,1,1)
    ,TODAY() - TableName[Request Date]
    ,TableName[Event Date] - TableName[Request Date]
)

 

  • Creative_tree88's avatar
    Creative_tree88
    Icon for Helper V rankHelper V
    3 years ago

    Many thanks!  Works like a charm.