IF(TIMEVALUE(CreatedDate) <= 19:00:00.000, 'TODAY', 'TOMORROW')

I am getting following error for the above formula. What could be possible cause?

Error: Syntax error. Missing ')'

1 Answer 1


https://help.salesforce.com/articleView?id=custom_field_time_overview.htm https://help.salesforce.com/articleView?id=formula_using_date_datetime.htm&type=5

enter image description here

You'll need to enclose the text in TIMEVALUE() to compare with a timevalue. Right now it acts as if 19:00:00.000 is text.

IF(TIMEVALUE(CreatedDate) <= TIMEVALUE('19:00:00.000'), 'TODAY', 'TOMORROW')

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .