Date filter without time element

Craig Hazell shared this question 1 week ago
Awaiting Reply

Hi,

I have a date field in a view and I'm looking to add a filter based on this in a report. When I run the report, the filter always chooses the current time which is not suitable, I need it to not filter based on the time or to default to 00:00:00.

The date field is purely a date e.g. convert(date,field) and so there is no time element.

Is this possible?

Comments (1)

photo
1

Hi Craig,


Thanks for reaching out with your issue.


I'm trying to recreate your situation on our side, so far I've been able to successfully define a date filter value in a report using Filter Formatting options: dabb573939aa31c865741832c43cafe4


This filter is applied as defined when I run the report. The timestamp below the title is the time at which the report is run:21e9fd4bd5cd039f6f93ba8982e77afa


One thing of note - there is no time reference at all in my filter - 00ca31627273d90b1376bb9c190c9e38


Could you help me attempt to replicate this issue by providing some additional information -


-screenshots of the behavior

-screenshots of the filter's configuration

-sql statement of the report


Thanks,Eric