Filters > Record Selection for dates between

[inkbird01]

Hi, needing help with filtering only yesterday and todays dates
have tried the following with no luck

{Table.Date} > currentdate -1
{table.Date} = currentdate

Thanks

 

[pmax9999]

Hi inkbird01 and welcome to TekTips.

It is always helpful to detail the actual result of anything you have tried, rather than saying 'No luck'. Did it return an error? How did the results vary from what you were expecting?

Try the following in the Record Selection Formula:

[Code RecordSelectionFormula]
{Table.Date} = CurrentDate - 1 OR
{Table.Date} = CurrentDate
[/Code]

The approach could be simplified if {Table.Date} is never going to be later than "now" in which case a simple {Table.Date} => CurrentDate - 1 should work.

Please note you may need to change the approach if {Table.Date} is a date/time field rather than a pure date field. In that case try converting the date/time field to a date using Date({Table.Date}).

Hope this helps.

Cheers
Pete

 

[pmax9999]

If you are not going to acknowledge the assistance and provide feedback on whether it worked or not, I'd suggest you might struggle to get further assistance in the future if you need it.

 

[inkbird01]

Thanks Pete, I used chat GPT that gave me a better response

 

[pmax9999]

Maybe you could share the solution for the benefit of others facing a similar challenge.