Forum Discussion
Advanced Date Filter Automatically adds current time
Hi All,
I recently noticed that when i add a date filter in my filter panel, switch it to advanced with 'is', select a date: it will add the current hour and minutes to it.
How can i change this?
i use a seperate date table, with just dates, no times attached. And i want to filter my report using the filter panel. Seemed to be working before, but now it doesnt. When I change back the time to 12:00 AM, it works again.
I want to prevent the time slot from filling, as i'm just looking for a specific date. I hate to use a slicer on the report, all my filters are hidden in the filter panel 🙂
No date selectedWhen a date is selected
You can refer to the following message.
4 Replies
- amitchandakSuper User
Change the data type date from datetime
- AnonymousNot applicable
Hi Amitchandak,
That is the first thing I tried. It's set to a date type. It seems to work okay in the desktop, but it fails in the service.
Here is the filter and the table
- v-chuncz-msftCommunity Support
You can refer to the following message.