How to change the Date format from String to "MM/DD/YYYY" ?

[prduddu]

Hi All,

I have a date column with the Date values as "Jul-17","Aug-17",....."Dec-18". This is by default coming in as string format and we will have no control of changing the format of it. How can I change the format to "MM/DD/YYYY" for this?

Thanks

Prash

[v-yuezhe-msft]

@prduddu,

Please click the date column in the Fields panel, then click on Modeling in the Desktop ribbon and change data type of the column to Date and change date format to MM/dd/yyyy.

 

Regards,

[Anonymous]

Create a calculated column... and try this...

Column = FORMAT(Table1[Column1],"MM/DD/YYYY")