Date time conversion going wrong

Question

Hello,

I have a column DMY with the following value:

01022024

I am using date time tool to convert the format:

Using custom input format: ddmmyyyy

Output column name is date.

The output I am getting is 2024-01-01

Shouldn't it be 2024-02-01? What is going wrong?

Deano478 · Answer

hey @Isha_Gupta remove the datetimetool and give this formula a go it should do the trick just create a new filed and set it to Date type

DateTimeParse([Input],"%d%m%Y")

DataNath · Answer

Hey @Isha_Gupta, when using the DateTime tool, the month specifier is MM rather than mm and so you should be using ddMMyyyy instead. More info on this page: https://help.alteryx.com/2018.3/DateTime.htm?Highlight=date%20time

aatalai · Answer

try using the formula tool with DateTimeFormat([DateTime_Out],"%Y-%m-%d")

Here's some more info too https://help.alteryx.com/current/en/designer/functions/conversion-functions.html#idm45934712704128