Trouble converting mmddyyyy string to date accurately. Month is inaccurate.

[wonka1234]

Hi,

What am I doing wrong here.

I have the string 07252023  trying to convert it to date format.

I mam using the DateTime Tool.  String to Date format , Custom "mmddyyyy" and it is returning "2023-01-25 00:07:00".

why is the month wrong here?

[DataNath · Accepted solution]

Hey @wonka1234 - check out the Custom Format section here: https://help.alteryx.com/20231/designer/datetime-tool - the specifiers are slightly different for the DateTime tool so you'd actually want to be using MMddyyyy, with the capital MM. 'mm' here is minutes.

[wonka1234]

@DataNath  AH **bleep**! Im such A FOOL!!! thanks.

[ChrisTX]

for month use capital M

seems to be the opposite of the DateTime functions DateTime Functions | Alteryx Help

Chris