How to compare the date in filter.......

[Former Member]

Hi,

I want to put the filter on the expiration date in Free characteristics. I need all the stock for which the expiration date is less than or equal to the current date.

I guess I need to create a variable for this , any suggestions ?

Thanks , Jeetu

[Former Member · Accepted solution]

Hi Jeetu,

you could just create a variable on the experation date. In the selection window choose selection 'Value range' and choose in the listbox next to it 'Less than or equal'. Now drag the variable 'Current calendar day' into the Selection box.

This should do the trick.

regards,

Raymond Baggen

Uphantis bv