Date Conversions

[Cooper_yonk]

Hi peeps.

Does anyone know how I would turn a date 20/02/2016 which has come into alteryx as a text field, into a date?

[gotu]

IF anyone can help me in suggesting the way to convert the date format as DD.MM.YYYY to YYYY-mm-dd using the formula tool

[JohnJPS]

@gotu 

DateTimeFormat(DateTimeParse([DateAsString],"%d.%m.%Y"),"%Y-%m-%d")

This will parse "DateAsString" from provided in the given format... and then format it to the desired format.

See their documentation for more info.

Hope that help,

John

[gotu]

thank you so much for your advise.. It really helped me...