We've updated the ServiceNow Community Code of Conduct, adding guidelines around AI usage, professionalism, and content violations. Read more

how to get only only date from created in reports

Supriya KM
Tera Contributor

Hello Everyone,

I am trying to create one report on incident and i want to have only date without time. I have tried using configure function field but couldn't achieve it. Can anyone help me with this.

2 REPLIES 2

SyamPrasanM
Tera Expert

Hi @Supriya KM,

I hope this solution is useful to your requirement 

 

Using Report Configuration

  1. Create a New Report:

    • Go to Reports > Create New and select the type of report you want (e.g., List, Pie Chart, etc.).
  2. Select the Incident Table:

    • Choose the incident table as your data source.
  3. Configure the Report:

    • In the report configuration, add the date field you want to display (e.g., opened_at).
    • In the Columns section, you can format the date.
    • Use the Date Format option to display the date without the time. You can set it to a format like MM/DD/YYYY or YYYY-MM-DD.

Screenshot 2024-10-25 155105.png

 

Best Regards,

Mule Syam 

PRAVAL-LOGO.png

abbasshaik4
Tera Sage

Hi @Supriya KM,

Please refer to the below screenshot:

Abbas_5_0-1729921249941.png


If it is helpful, please mark it as helpful and accept the correct solution. In future, it might be helpful for someone to refer to this solution.

Thanks & Regards,

Abbas Shaik