Forum Discussion
Bansi008
2 years agoHelper III
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 ot...
- 2 years ago
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
- Anonymous2 years ago
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
2 years agoSuper User
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