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!!

[Ankur Bawiskar]

@Dave Belgard 

Can you share how the output is when you apply above?

[Dave Belgard]

Original field was datetime.  New field is just date.

[geekhitesh]

this should be the best answer. 

[bhausen]

This is a working solution. The new field is stored at dictionary level (prefixed u_rpt_) and can be used in list views too.