DateTime Formatting

[dmill8023]

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 

[DataNath · Accepted 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!

[ChrisTX · Accepted solution]

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

[CathyS_Slalom · Accepted solution]

Hi @dmill8023, you can use the DateTimeParse function:

[dmill8023]

Thank you everyone for the suggestions!  I tried both the DateTimeParse function as well DateTime tool and got the solution I was looking for!