[Kyle Glynn]

I created a workflow that populates a revenue recognition start/end date line based upon the transaction date. I tested the formula via saved search it works properly, but when I run it through the work flow I get an error message saying that the date is not in the proper format. The line field is MM/DD/YYYY and it seems to be converting it to a YYYY/MM/DD format. How do I add to my formula to ensure that the date format stays as MM/DD/YYYY? Below is the formula I am using.

CASE WHEN (TO_CHAR({trandate}, 'DD')) < '15' THEN TO_DATE(concat(CONCAT(TO_CHAR({trandate}, 'MM'), '15'), TO_CHAR({trandate}, 'YYYY'))) ELSE LAST_DAY{trandate} END
This is a cached copy. Click here to see the original post.

[rnedelkow]

I'm not too familiar with workflows, but the date format change may be caused by the date format configured under Home > Set Preferences > General.

[Kyle Glynn]

Robert- I checked those preferences and those are set correctly. I also checked the custom field I created for the Rev Rec line and that simply lists Date but doesn't have a formatting option.

[Author]

Posts