You need to sign in to do that
Don't have an account?
Binu 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?
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?
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.