Date format

[Hayley]

Hello everyone. I do have a date roll up Month and the Year in a pivot report, currently is it formatted as 'March 2021' using long date and I want to format to 'Mar 2021'

 

How can I do it? Thanks in advance.

[PotatoMato]

Hi @Hayley, you may use the custom format and insert this: MMM yyyy.

MMM - stands for the first three letters of the month.
yyyy - stands for the year.

You may also refer to the screenshot below.

 

- Potato

[GoodBoy]

Hi @Hayley!

Just want to add this useful HowTo article about Date formatting : https://howto.caspio.com/faq/caspio-bridge-8-4/different-formatting-when-using-field-parameter/

I hope this helps.