Parse DDMonYY to date

[Chirag_KRCPL]

String is in given format:

28SEP2021

How to parse it as date?

And can you please specify some reference link where I can find different date formats and their parsing methodology?

[DataNath · Accepted solution]

@Chirag_KRCPL you can use the DateTimeParse() function with the following specifiers:

The %d here represents a 1/2 digit day.

%m represents abbreviated months.

%Y signifies a 4-digit year.

More information on dateparse and the specifiers is available in the help documentation here: https://help.alteryx.com/20221/designer/datetime-functions

[JosephSerpis · Accepted solution]

Hi @Chirag_KRCPL this is the reference you need. The following formula would parse your date inside a formula tool.

DateTimeParse([your field],"%d%b%Y")

[Chirag_KRCPL]

I am using '%d%b%y' for date "18SEP52" but i is showing field conversion error - any idea on  this?

[DataNath · Accepted solution]

@Chirag_KRCPL can you share your flow or at least a screenshot or something? Struggling to replicate that behaviour:

[Chirag_KRCPL]

Hi @DataNath , I was actually applying the formula to the same field ("Input Format" in your case) instead of applying it on a new "Date" field.
This was causing field conversion error. However resolved now.

Many thanks for your response!!