Forum Discussion
Date Comparison
Hello,
I am wondering if someone can assist me with how to write the following statement that will be added to a Date Slicer.
IF Date_Closed Is >= Expected Dated_Closed, use Expected Date_Closed
Else use Date_Closed
where Status = Won
3 Replies
Anonymous , a new column
if([Status] = "Won", if([Date_Closed] > [Expected Dated_Closed] ,[Expected Dated_Closed] ,[Date_Closed]), blank())
Thank you for replying. It is still a bit off. Let me rephrase original:
IF Date_Closed Is >= Expected Dated_Closed, use Expected Date_Closed
Else use (Date_Closed where Status = Won)
Getting an error like this:
Compare_Dates = if([Status] = "Won" && if ([Date_closed] <> blank, if([Date_Closed] >= [Expected_Close_Date], [Expected_Close_Date] ,[Date_Closed]), blank()))of The syntax ',' is incorrect.
