Don,

What is your version/path level of MPE/iX?  I have seen where if you
are not on at least 5.5pp4, one of the MPE date intrinsics returns
a year field which is incorrect.  Perhaps this is your problem, not
AQ/3000.



At 11:41 AM 3/9/99 -0700, Inghram, Don wrote:
>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]
>
X-no-Archive:yes

/jf
                              _\\///_
                             (' o-o ')
___________________________ooOo_( )_OOoo____________________________________

                       Tuesday, March 9th

          Today in 1861 - The battle of the Union "Monitor" and the
                          Confederate "Merimack" took place.

___________________________________Oooo_____________________________________
                            oooO  (    )
                           (    )  )  /
                            \  (   (_/
                             \_)