How to filter records from Yesterday at 6AM to Today at 6 AM

[itd87]

Hello, 

I am trying to filter records in a table for a scheduled data export. I need the records to show only Yesterday (relative to the scheduled extract) at 6 AM, however when I change the time in that filter it will change 'Yesterday' to the hard-coded date of yesterday (screenshot). How can I keep the relative Yesterday instead of it changing to this hard-coded value, since I will want this extract to run every day. 

Likewise, I want the end filter to be Today at 6AM, and am running into the same issue when I try to add a time to the Today filter. How can I keep the relative Today and also add a time? 

Thank you! 

[Tsura Andreeva · Accepted solution]

You could use last 24 hours and when you run the export at 6 am it will be replative to that time

[AndersBGS]

Hi @itd87 ,

Below condition should do the trick:

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders 

[narendra1si]

Great, Thanks Anders