Forum Discussion
Atis112
3 years agoNew Member
Filter by date and time
Hello,
I would like to ask for help!
I would like to set up a dynamic filtering option that would pre-filter the data based on the criteria you specify.
The start date is always the previous day and 6am. The end date: is always today and 6am. So I want to see the data between the time interval. I could do this for date, but not for time.
In the table, the date and time are in two separate columns, if it is easier I can merge them.
What are the options?
Thank you very much for your help!
Best regards,
Atis
1 Reply
- lbendlinSuper User
Create a second date column that is shifted by 6 hours. Use that column for the filtering.