Conversion of Date & Time format

[RanjanKT]

Hi Team,

Can some one help me to convert the Below Date(MMDDYYYY HHMM) field to (YYYY-MM-DD) format.

I have tried using the  DateTimeParse([AnticipatedWinDate], "%Y-%m-%d") formula, But some how i am getting the error saying.

"ConvError: Formula (14): DATETIMEPARSE: Cannot convert "Oct 30 201" to a date/time with format "%YY-%m-%d": Expected a number for year: 'Oct 30 201'":

The format is as below.

[razoux1970]

Your string field (i.e. CREATE_DATE1) might have hidden characters. Did you try adding the Data Cleansing tool into your workflow? I had the same issue and it worked for me