I m trying to take a String field in the format of "DEC-2025" and convert it to a true date. Is that possible? Ive tried a few things but nothing works so far
Hi @timman
You want to use the DATETIMEPARSE() function
datetimeparse([field],'%b-%Y')
should convert that format into a date
There's more info on the specifiers here: https://help.alteryx.com/current/en/designer/functions/datetime-functions.html#specifiers
Couldn't remember what Alteryx did with the missing "day" value in @OllieClarke's solution. Curiosity got the better of me (or a quick opportunity to build an illustration for myself). Here's what it does:<spoiler, it just defaults to the first day of the month>
Thank you both so much that worked!
You may also consider using the DateTime tool (which is more intuitive on the configuration tab), although it only allows you to convert one column at a time.
