+ Start a Discussion
Binu 8Binu 8 

Text formula not working

HI team,

I have custom formula date  field in Oppertunity Product  which is "Renew Date".
Now I want to create a text formula based on that formula date field.
My formula is,


When I am checkin the syntax this error is showing, "Incorrect parameter type for operator '<'. Expected DateTime, received Date".

Could you please solve this?

Akhil AnilAkhil Anil
Your Formula should be like this 


Your RenewDate__c custom field is a DateTime field. So, you should be using the system's Datetime field for comparison. Today() return only the Date, whereas Now() returns the Datetime value.