How would i change date format

[Bansi008]

Hi,

In date column, currently i have value as 2024-02-29T00:00:00Z which i want convert into 02/29/2024 format in the new column. what formula would i use in the cutom column? or do we I have any other solution to handle this?

[Gabry · Accepted solution]

If you don't need timestamp you can convert your column to date
data view, select the date column, under data type choose date instead of date/time

let me know

[Anonymous · Accepted solution]

Hi  @Bansi008 ,

Thank for @Gabry  answer. That is great. I have some other solutions:

Below is my table:

You can click the format:

The final output is like this:

Solution 2 :

You can create a column:

Column = FORMAT('Table'[Date],"mm/dd/yyyy")

The final output is like this:

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Gabry · Accepted solution]

If you don't need timestamp you can convert your column to date
data view, select the date column, under data type choose date instead of date/time

let me know