Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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!!!
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!!!
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
Thanks,
I will get updated today and try.
DQ
Hi,
I cannot currently upgrade....IS there another way to get the achieved please
?
Thank you
DQ