Formatting of date

[Belletmns]

Hi All,

I need to format below dates to "dd-mm-yyyy" (example in should be column). When using datetimetool I'm having error that the date in the below is not in valid format.

Thanks!

[grazitti_sapna · Accepted solution]

Hi @Belletmns , try this.

Formula

DatetimeFOrmat(DateTimeParse(Date,"%m/%d/%Y"),"%d-%m-%Y")

Thanks.

[Himanshu_1984]

you can use the datetime formatting option in formula tool  "DateTimeFormat([DateTime_Out], "%d-%m-%Y")" but it will be in a string format only because Alteryx's default date format is "YYYY-MM-DD"

Regards,

Himanshu

[ttiverson98]

I have the following data and need it to be read as a date.  I changed the Value Date to "date" under type, but it still comes up as Null.

Thanks, Todd

[Luke_C]

Hi @ttiverson98 

You can use the DateTime or formula tool to convert it to a date. Alteryx only reads dates in yyyy-mm-dd format, simply updating the data type won't work because your data is not in the correct format. See attached, both tools are essentially doing the same thing, creating a date field by telling alteryx the data is structured as %Y%m%d.

More info on date functions: https://help.alteryx.com/current/designer/datetime-functions

[Emil_Kos]

Hi @ttiverson98,

You need to tell Alteryx how to read this date. I have prepared a workflow for you!

[ttiverson98]

Thank You, works perfectly.