Forum Discussion

Bansi008's avatar
Bansi008
Helper III
2 years ago
Solved

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...
  • Gabry's avatar
    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/time

     

     

    let me know

  • Anonymous's avatar
    Anonymous
    2 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.