Format dates to YYYY_MO_DA

[Khristian_Evans]

Hi, I need help with changing the format of my date outputs. 

[binuacs]

@Khristian_Evans what is this format MO and DA?

[Khristian_Evans]

Year , Month, Date 

2024 - 05 - 14 for today as an example

[Khristian_Evans]

@binuacs the format is currently 5/14/2024 and I want to change to 2024-05-14

[binuacs]

@Khristian_Evans what is your input data format? Can you give a sample data?

[binuacs · Accepted solution]

@Khristian_Evans you can use the DateTimeFormat function to convert a date from the ISO format to any other format

[Blockprogramming]

Use the DateTime tool. Select the incoming field option of "MM/dd/yyyy".

 

[binuacs]

@Khristian_Evans If your date is not ISO format (YYYY-MM-DD) then you need to use the DateTimeParse tool to change it into the Alteryx date format which is in YYYY-MM-DD