Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Change Date format to MMM/YYYY

I am looking to change my date format to MMM/YYYY. This is not an option an existing data format option. I have tried creating the below calculated column, but it changes the data type to text and th...
Need Help
FrankAT's avatar
FrankAT
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Anonymous,

the function FORMAT() returns a string. You can set the desired format in model view:

  1. Select the date column.
  2. In properties pane open date time format and choose Custom.
  3. Set your desired date format to mmm yyyy and press Enter.

That's is

 

 

Regards FrankAT