I’m trying to build a workflow to automate setting some dates on purchase order lines. I have a date field, and I’m trying to write a formula to add 10 days and set the result into a new field. I have everything setup correctly, but when the workflow executes I get the following error:

You have entered an Invalid Field Value 2018-10-08 00:00:00 for the following field: custcol_ov_proj_indc_date

The date is correct, but it looks like its setting a datetime instead? This is the formula I am using:

TO_DATE({line.custcol_ov_confirmed_date}) + 10

Anyone have any pointers or seen this problem before? I can confirm both

custcol_ov_confirmed_date

and

custcol_ov_proj_indc_date

are date objects.