Conversion of Date & Time format

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.

Date Time

Accepted answers

All comments

LordNeilLord

Hey @RanjanKT

DateTimeParse wants you to specify the format that the data is currently in, not what you want it output like

MarqueeCrew

@RanjanKT ,

Please try this:

DateTimeParse(Left([AnticipatedWinDate],11), "%b %d %Y")

Cheers,

Mark

JosephSerpis

Hi @RanjanKT if you use the datetime tool and following format it should work.

RanjanKT

Thanks for the response.

encountering the below error.

ConvError: Formula (14): DATETIMEPARSE: Cannot convert "Oct 30 201" to a date/time with format "%b %d %Y": Year number is out of range 1400..9999: '201'

and the dated are appearing "Oct 30 201"

RanjanKT

Thanks for the response.

For some reason i am getting the below error.

ConvError: DateTime (25): DateTime_Out: Cannot convert "Oct 30 201" to a date/time with format "%m/%d/%Y %H:%M:%S": Expected a number for Month: 'Oct 30 201' Record #5

RanjanKT

i have tried both the possibilities. But the Out put is reflecting null. and the existing field format is changing.

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

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

michael_weaver 335

Hollingsworth 335