Formatting of date

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!

Date Time

Accepted answers

Hi @Belletmns , try this.

Formula

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

Thanks.

datetimeformat-GS.yxmd

All comments

Hi @Belletmns , try this.

Formula

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

Thanks.

datetimeformat-GS.yxmd

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

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

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703