I am trying to set a workflow condition to generate an error after field edit, if the date field is older than today. However my formula condition is not working...my formula is:

TO_DATE({trandate},'MM/DD/YYYY') < TO_DATE({today},'MM/DD/YYYY')

Any ideas? Is my syntax incorrect due to it being client side action?

Fantastic, thank you, exactly what I was looking for. Not sure how I missed it!

try to hard code date to test {trandate} < {trandate}<TO_DATE('01/01/24', 'MM/DD/YYYY') Try : nlapiStringToDate(nlapiGetFieldValue('trandate')).getTime() < new Date().getTime() Or use saved search condition in your wf On the SS use criteria like CASE WHEN {trandate} < {today} THEN 1 END