How to format a date column to MM/dd/yyyy or MM-dd-yyyy without creating a new column ? The Change Type will give something like mm*dd*yyyy but it drops the leading zero for single digit months (Jan, Feb etc.), which is what we don't want.

[Trifacta_Alumni · Accepted solution]

Hi @Gabby Deal? you can use do that in two ways.

1. Search Transformation(not function) Date Format. Choose the columns and and choose the desired dateformat from Output format drop down. Attaching screenshot

2. Search Transformation - Edit column with Formula, choose datetype columns and in Formula field search for DATEFORMAT() function. Attaching screenshot. You put multiple datetime columns and refer them as $col as DATEFORMAT($col,"MM-dd-yyyy")

Hope this helps.

Best

Vardan

[Trifacta_Alumni]

Hi @Gabby Deal?, curious to know if this helped or is there something else you were looking for.

[GD88]

Thanks Vardan. Yup, this is what I was looking for.

[Trifacta_Alumni]

Glad it worked!