Show only records with a valid expiration date

[Anonymous]

Hello,

I'm trying to figure out how to show accounts whose expiration dates are valid and of certain groups.

I have vendor accounts that share account numbers however one entry is valid and one is not.  The only way to determine this is to look at the expiration date, VALIDTO.

Here's my set analysis that I'm currently using however it still shows duplicate account numbers and doesn't seem to be filtering on VALIDTO.

only({$<VENDGROUP = {1,2,3,4}, VALIDTO= {">=$(today())"} >}  ACCOUNTNUM)

Any help is greatly appreciated.

[Anonymous]

Try this, it should work:

only({$<VENDGROUP = {1,2,3,4}, VALIDTO= {"$(='>=' & today())"}  >}  ACCOUNTNUM)

Regards,

Michael

[Anonymous]

This wasn't working either; however, I was able to solve the issue using an IF statement instead.

Thank you for your response though.