How to Format the date values in ServiceNow reporting

[Muradz1234567]

Hi I would like to format the date values from i.e. Monday/2014 to "Mon-01-2014". In this possible in ServiceNow reporting. Would appreciate the help.

[Tony Chatfield1]

Hi, 1 option would be to use custom report 'function' fields, this effectively creates a new field on your reporting table, allowing you to configure the content using a limited sets of scripting type functions.

https://docs.servicenow.com/en-US/bundle/utah-now-intelligence/page/use/reporting/concept/function-f...

Another option is to create a new field on the table and set the content via BR during the before insert\update process.
They both provide the same results...more/less,
With the report function being easier for some scenarios as it doesn't require an admin user and scripting.
However depending on requirements, a BR type scripted solution will allow you to leverage a wider range of code\functionality and reference data.

[larsbager]

unfortunately the "function" field doesnt seem to offer any "format" options...?

[AndersBGS]

Hi @Muradz1234567 ,

As @Tony Chatfield1 have mentioned, there are several possibilities to leverage function fields, new custom fields. Though I would recommend to do this, "just" to get another visualization. Could it be that you should change the condition on the report instead and by that narrow down the report? 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders 

[Muradz1234567]

How would you go about if going for creating function in the report designer with the limited functions.