Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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_Clo...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    I was able to resolved as such:

     

amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , a new column

 

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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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.