+ 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,

IF(RenewDate__c<Today(),"active","unpaid");

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 

IF(RenewDate__c<NOW(),"active","unpaid");

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.