Button to select older than today

[davyqliks]

Hi,

In my model i have a field Expiry Date.

i wish to have a button that filters where the expiry dat is older than today.

I create the button

Select Values in Field

Fields Expiry date

Value 

=[Expiry date] < today()

this is not selecting the dates in the fields older than today.

This is odd as i have a background colour on the expiry dates using a similar expression, below.

=If([Expiry date] < today() ,RGB(204, 101, 118),
If([Expiry date] < today() +30 ,RGB(220, 204, 119),

))

can anyone inform why the button is not filtering as i hoped. thanks

DQ

[QFabian · Accepted solution]

Hi, please try this :

1.- Create a variable using :

vToday = num(Today())

2,. Select 'Select values matching search criteria' as Action option :

3.- Use this in Value :

='< $(vToday)'

It works!!!

[davyqliks]

Hi,

Thanks so much for your time.

I don't seem to have the same action options as you.

is there another option that will work?

Thanks

[QFabian]

hi @davyqliks , i'm working with newest version

[davyqliks]

Thanks,

I will get updated today and try.

DQ

[davyqliks]

Hi,

I cannot currently upgrade....IS there another way to get the achieved please

?

Thank you

DQ