Button to select from a specific date

[peterderrington]

Hi, 

A simple this one i'm sure. I have a few buttons that allow me to select data from the last 7, 14 and 30 days.

They all use an adaption of this: ='>=$(=(Date(Today()-7)))<=$(=(Date(Today()-0)))'

What i need now is a button that selects all data from a specific date (01/01/2019) but i can't quite work out the syntax.

Can anyone help?

Thanks.

[Anil_Babu_Samineni]

Create button -> Actions tab -> Add -> Select in field -> DateField as Field and string as follows. Make sure about your Date format.

='>=' & Date(Max(DateField-7)) & '<=' & Date(Max(DateField))

[peterderrington]

Sorry for the late reply, work commitments!

So i tried your formula and obviously i haven't done it correctly, i need to understand where i need to put the specific date in that i want it to show results from, the formula that you have given me just shows all the data.

[peterderrington]

Can anybody else help here?

Just need to be able to filter my results from a specific date with a simple button.