Convert string YYYMMMDD to date with the same format YYYYMMDD

[JosephOpenshaw]

This is probably a simple thing, but I could use some help.

I have to convert string YYYMMMDD to date with the same format YYYYMMDD.

Any assistance is appreciated.

[JosephSerpis · Accepted solution]

Hi @JosephOpenshaw the only recognized data format in alteryx is YYYY-MM-DD. Any other format would be considered a string format in alteryx. The reason for this is that the date time functions only work with one format. I've attached a workflow which shows this.

[ChrisTX · Accepted solution]

Use a formula tool with the DateTimeParse function

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

Here is a list of all functions: https://help.alteryx.com/current/Reference/Functions.htm

[JosephOpenshaw]

This did the trick. Thank you @joseph and @ChrisTX !