Date time conversion going wrong

[Isha_Gupta]

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?

[aatalai]

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

[DataNath]

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

[Deano478]

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")