I have a form with an optiongroup named frame32, and 4 dates named InvDate, InvDate1, DueDate and Duedate1. I am trying to open this form from an on click event on my switchboard with the following criteria:
When Frame 32 is 1, Then Invdate = < Date() and DueDate = < Date() and
When Frame 32 is 0, Then InvDate1 =<Date() and DueDate1=<Date().
I am trying to filter the records that are expired. I tried every possible combination of strings but am just not able to find one that works, probably because I am still a novice. Any help is really appreciated.
Thanks
Bert.