Creating an IF formula field for a custom module based on a date field to return a text value
I have a customer module, and in it I have a start date and an end date.
I want to create a custom field with a formula that says:
If [End date] is today or less, then "Expired" else "Valid"
I have tried a ton of times to get this to work but I feel like zoho doesn't like mixing dates with text returns?? eg:
If(${Support Contracts.End Date}<=Now(),'Expired','Valid')
I receive this message
You used the wrong type of data in an argument. Check what you entered between the parentheses of your functions to make sure you put the right kind of data in the right place.