Date conversion Jan 2018 to 2018-01-01

[mikegauntlett]

Hi I have a Field in my data that is populated by Jan 18, as the Month and Year.

Is there any way to convert it into 'yyyy MM dd' ?

I have looked at inline tables but there are to many variables.

Many Thanks

[Ivan_Bozov]

Hello, maybe this in the script:

Date(Date#(YourDateField, 'MMM YYYY'), 'YYYY.MM.DD') AS YourDateField

[sunny_talwar]

Also, look at these threads

Why don’t my dates work?

Get the Dates Right

[shraddha_g]

Try Date(Date#(YourDateField, 'MMM YYYY'), 'YYYY-MM-DD')

[mikegauntlett]

Thanks Ivan, that worked