Filter Custom Reports based on a datetime column


I am creating a Custom Report based on a table. In the table I have a datetime column only. There is no date column.

I am trying to use the datetime column to filter report data by date/datetime. However, the report fails. Please suggest how to use a datetime column tp filter data in Custom Reports.

Hi! Jane,

Custom Reports allows to filter by date only using Date columns. You can using functions to convert a datetime column to date and use it to filter custom reports.

For e.g. CAST(datetime column name AS date)