How to change date format of reports?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-29-2022 02:22 AM
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.
- Labels:
-
Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-29-2022 02:26 AM
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
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-31-2022 09:40 PM
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
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-29-2022 02:28 AM
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