I want to add a red flag to an Opportunity if it has not been updated by a Sales rep for more than 30 days. If it has been updated, then for a green flag to show.
At the moment my formula is:
IF(LastModifiedDate - DATEVALUE(NOW()) > 30, IMAGE("/img/samples/flag_red.gif", "RED"), IMAGE("/img/samples/flag_green.gif", "GREEN"))
However I am receiving error message: Error: Incorrect parameter type for operator '-'. Expected Number, DateTime, received Date
Any help would be appreciated - thank you!
10 respuestas
Eric Praud (Activ8 Solar Energies) 
Forum Ambassador
Are you getting an error?
Actually, I just saw an error, NOW() and LastModified Date shoudl be inverted:
IF(NOW()-LastModifiedDate > 30, IMAGE("/img/samples/flag_red.gif", "RED"), IMAGE("/img/samples/flag_green.gif", "GREEN"))
