Forum Discussion
How would i change date format
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?
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/timelet me know
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.
2 Replies
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/timelet me know
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.