Date Comparison

[Anonymous]

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

[Anonymous · Accepted solution]

I was able to resolved as such:

[amitchandak]

@Anonymous , a new column

if([Status] = "Won", if([Date_Closed] > [Expected Dated_Closed] ,[Expected Dated_Closed] ,[Date_Closed]), blank())

[Anonymous]

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.