Convert date and time field to date field on report in ServiceNow

[Surendra6]

We have to change the date and time value to data value in reports. How can we achieve this functionality.

Thank you!!

[Aman Kumar S]

Explain your use case a bit here?

Reports are just presentation for data residing in your tables, you can't change the type in a report

[Ankur Bawiskar]

Hi,

not possible.

If it's a date/time field you cannot just show Date there

Regards
Ankur

[Mark Manders]

What kind of reports are you creating? Why do you need to change the date/time to date? You can always work around it by creating a custom date field and copy the date/time field to that new field and use that for reporting, but the time behind a date field shouldn't prevent you from making reports (if you create a report on 'created' of tickets, you will see it's selected by date, even though 'created' is a date/time field.

Like with everything: ask yourself the 'why' question.

If my answer helped you in any way, please then mark it as helpful.

Mark

[Dave Belgard]

absolutely possible ... with a little bit of creativity. See picture below: