Fellow listers, We have for many years used AQ/3000 from the Contributed Library as an alternative to Query. In considering switching to Query to resolve a Y2K issue, I am stumped by my inability to find a date function that works correspondingly to the TODAY value in AQ. For example, in AQ I can say "FIND TRANSACT.MONTH = TODAY:(1,2) - 1" to find all records with last month's date, using the fact that TODAY always has the form xx/xx/xx with today's date in it and therefore TODAY:(1,2) gives me the current month. Is there something in Query that provides today's date in a similar manipulatable form? Our preference would be to stay with AQ, but TODAY appears to give a result of 01/20/:0 on Jan. 20, 2000 when we try it with SETDATE. Perhaps one of you has a solution for this problem. Thanks for any hints. Don Inghram, Systems Mgr. The Christian & Missionary Alliance Colorado Springs, CO (719) 265-2154 [log in to unmask]