How to change date format of reports?

Arun98
Tera Contributor

Hi Experts,

In the below image you can see that I've sorted request based on week and the format of week is yyyy-mm-dd(2022-02-23) and I want to change it to yyyy-month_name-dd(2022-Feb-23).

Can someone please help me through this.

find_real_file.png

3 REPLIES 3

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

As per my understanding it shows the date format as per logged in users date format or the system date format.

Did you try changing your date format to another one and see if it shows that format? that would confirm the case.

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

@Arun 

Hope you are doing good.

Did my reply answer your question?

If my response helped please close the thread by marking appropriate response as correct so that it benefits future readers.

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

Mahak2
Kilo Guru

Hello,

Another workaround is mentioned below:

You will have to create custom date field on your table to convert date format as per your requirements. Then, you can report on this custom date field. You will have to create custom date field on your table to convert date format as per your requirements. Then, you can report on this custom date field.

Please mark my response as helpful and correct as applicable.

Thanks