DateTime question creting new colums

Question

Hi All,

I have a column with dates that I need to transform to 1) show today’s date, 2) with format %d-%b-%y (like 13-Sep-22) and 3) the new final Colum  has to be data type “date” (no String).

I have tried using DateTimeFormat & DateTimeParse formulas and I can’t get the combination %d-%b-%y & Data type ”Date” in the same column.

Please see below. I appreciate your help.

Thank you

GR

Date Example.yxmd

DataNath · Accepted Answer

Unfortunately this is impossible @grromerro. Alteryx only deals with dates in YYYY-MM-DD format. If it's not presented like that, it can only be processed as a string: https://help.alteryx.com/20221/designer/datetime-functions

What's the bigger picture here? Could perhaps suggest alternatives or workarounds.