Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Date formatting dd-mmm-yyyy

Hi, I see aa bunch of posts here that say to format a date in the above format i need to use the following script:

Column = FORMAT('Incident Flash report'[DateOfIncident],"dd-mmm-yyyy")
 
I added a column with that script , but it still shows the old format:
 

 

 

What am I missing here?

 

Thanks

 

  • Check the data type of this column. If it is text, it must be displayed in that format. If your date, change it to text

2 Replies

  • Check the data type of this column. If it is text, it must be displayed in that format. If your date, change it to text

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion

    Ack! Don't do that, that changes it to text, just use a custom date format here:

     

    For some reason, screen shot is not showing up. I attached it.