If we could use minor calculations in queries, that would be wonderful.
For example, our staff receive memberships as a benefit after 90 days of employment. We track our employees via a staff constituency. If the logical section of a query could match...
Constituency = Staff
& Constituency date from [on or before] Today - 90
& ( Constituency date to = Blank
+ Constituency date to [after] Today )
That would help us tremendously. There are definitely other applications to this request, but this one is top of mind at the time of posting.
Randall Rupert
| Customer references | Bok Tower Gardens |
