Button to show data older than 3 months

[davyqliks]

Hi all, 

I have a field [Last Order Date] which is a date field i have split into Month, Year and MonthYear.

I am looking to make a button to show data which is  older than [Last Order Date] + 3 months

Maybe to select the last 3 months and select the excluded?

Or, an expression to show data older than 3 months for highlighting stock.

I have tried to make a variable and then apply that to a button but could not work out the syntax for Month -3

Thank you in advance if you are able to assist with this.

Daniel

[Taoufiq_Zarra · Accepted solution]

have you tested addmonths funtion

for example :

=Date(addmonths(Date(Max([Last Order Date])),3))

Max is just an example.

you can share a sample data and the expected output