Data Selection using Event Rule in TR 8.96.40
One of my custom payroll table have YR, and MNTH. But I need to do from-to filter by date.
Unfortunately, I cannot add another column to have the complete date.
I cannot also use data selection in design mode, because it will do wrong filtering. For example,
From Year: 16
From Month: 8
From Year: 17
To Month: 1
If I just do YR >= From Year
AND YR <= To Year
AND MNTH >= From Month
AND MNTH <= To Month
The third and fourth conditions contradicts and will not give any data.
How can I do this using ER code ?
0