Subject: | |
From: | |
Reply To: | Inghram, Don |
Date: | Tue, 9 Mar 1999 11:41:16 -0700 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
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]
|
|
|