https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/DateTime-Tool-Converting-Dates-Incorrectly-from-February-to/m-p/1240729#M308548 <P>I am having an issue where my DateTime tool is converting every single date from February to January for no apparent reason. I have attached the configuration to this post as well as an example of what I am getting for an output. Any insight would be greatly appreciated!</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="DateTime Issue Example 1.PNG" style="width: 469px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/341555i008140B69CCBF109/image-size/large?v=v2&amp;px=999" role="button" title="DateTime Issue Example 1.PNG" alt="DateTime Issue Example 1.PNG" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="DateTime Issue Example 2.PNG" style="width: 275px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/341556iA11E8298BB504B5C/image-size/large?v=v2&amp;px=999" role="button" title="DateTime Issue Example 2.PNG" alt="DateTime Issue Example 2.PNG" /></span></P> Wed, 14 Feb 2024 17:04:41 GMT BPinkerman21 2024-02-14T17:04:41Z https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/DateTime-Tool-Converting-Dates-Incorrectly-from-February-to/m-p/1240729#M308548 <P>I am having an issue where my DateTime tool is converting every single date from February to January for no apparent reason. I have attached the configuration to this post as well as an example of what I am getting for an output. Any insight would be greatly appreciated!</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="DateTime Issue Example 1.PNG" style="width: 469px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/341555i008140B69CCBF109/image-size/large?v=v2&amp;px=999" role="button" title="DateTime Issue Example 1.PNG" alt="DateTime Issue Example 1.PNG" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="DateTime Issue Example 2.PNG" style="width: 275px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/341556iA11E8298BB504B5C/image-size/large?v=v2&amp;px=999" role="button" title="DateTime Issue Example 2.PNG" alt="DateTime Issue Example 2.PNG" /></span></P> Wed, 14 Feb 2024 17:04:41 GMT https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/DateTime-Tool-Converting-Dates-Incorrectly-from-February-to/m-p/1240729#M308548 BPinkerman21 2024-02-14T17:04:41Z https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/DateTime-Tool-Converting-Dates-Incorrectly-from-February-to/m-p/1240731#M308550 <P>You need MM for month, not mm! yyyyMMdd hhmmss</P> Wed, 14 Feb 2024 17:08:02 GMT https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/DateTime-Tool-Converting-Dates-Incorrectly-from-February-to/m-p/1240731#M308550 alexnajm 2024-02-14T17:08:02Z https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/DateTime-Tool-Converting-Dates-Incorrectly-from-February-to/m-p/1240733#M308552 <P>Thank you very much!</P> Wed, 14 Feb 2024 17:10:10 GMT https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/DateTime-Tool-Converting-Dates-Incorrectly-from-February-to/m-p/1240733#M308552 BPinkerman21 2024-02-14T17:10:10Z https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/DateTime-Tool-Converting-Dates-Incorrectly-from-February-to/m-p/1240734#M308553 <P><a href="https://community.alteryx.com/t5/user/viewprofilepage/user-id/477780">@BPinkerman21</a>&nbsp;try this in the fomrula tool instead</P><P>&nbsp;</P><P>DateTimeParse([Date_time],"%Y%m%d ,<SPAN>%H%M%S</SPAN>")</P> Wed, 14 Feb 2024 17:10:45 GMT https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/DateTime-Tool-Converting-Dates-Incorrectly-from-February-to/m-p/1240734#M308553 aatalai 2024-02-14T17:10:45Z