Query - Add Value Functions. (Quick example: Today)
Add value functions where the value would be retrieved at run time. A simple example would be LIST STU ID NM ED LD IF ED <= @@Today AND ( LD = NULL OR LD >= @@Today ) This would make queries a much more viable option for disseminating information in a school district with too many people to train on the intricacies of Query.
10
votes

-
Adam VeVea commented
Add a special field that specifies the current system date, so when doing date comparisons in queries you can filter by system date when looking at student enter dates, etc.