i wanted to do this functionality in my formula field. There is a PICKLIST field name stage called "OPENED". i want to check how long this pick list is being opened.
In formula editor I'm trying to do with NUMBER/DATE/DATETIME.
IF(ISPICKVAL(StageName, "OEF Clarification required stage"), TODAY() - LastModifiedDate, 0)
im getting this ERROR "
Error: Incorrect parameter type for operator '-'. Expected Number, Date, received DateTime".