Filter Result Based On Current Year

[Anonymous]

Hello Everyone!

I have a table which has few columns such as ID, Date, Expiry Date. So what I am trying to do is to count any row that has expiry date less than current date.

Waiting for your kind response.

[sunny_talwar]

May be like this:

Count({<[Expiry Date] = {"$(='<=' & Date(Today(), 'ExpiryDateFormatHere))"}>} ID)