Hello all! I have multiple data fields that I am looking to format to ISO format. Below are two mocked fields that contain dates I'm looking to format into the ISO format. Any help here would be appreciated!
They are currently defaulting to V_String date type.
Date Opened: 5/10/2022 2:52:00 AM
Entry Date: 5/10/2022 4:46:00 PM
Solved! Go to Solution.
DateTimeParse([FieldName], ‘%d/%m/%Y %I:%M:%S %p’)
Should do the trick, replacing ‘FieldName’ with the column you need to apply it to!
Try the DateTime tool with this custom format:
%m/%d/%Y %I:%M:%S %p
Documentation: https://help.alteryx.com/20221/designer/datetime-functions
The DateTimeParse function in a Multi-Field tool would also work.
Chris
Thank you everyone for the suggestions! I tried both the DateTimeParse function as well DateTime tool and got the solution I was looking for!