Re: JBA date manipulation with DB2 Query manager

[Pete Massiello <pmassiello@xxxxxxxxxxxxxxxx>]

Dan,

    Check out our ShowMe/400 product at http://www.os-solutions.com  We can do
the date manipulation, convert the format of the date as well as a lot more. In
addition, we can convert these Queries into RPG & DDS, as well as create drill
down inquires.

    Pete Massiello

Dan Thomas wrote:

> JBA dates are stored as a seven digit number in the format CYYMMDD, where
> century 1900 is a zero and 2000 is a one.  Any suggestions for being able to
> do date manipulation (aging, days difference, etc) within DB2 query manager
> and/or PC report writers like IQ Objects and Crystal Reports?
>
> Dan Thomas
> Sr. VP Information Systems
> Medical Distribution, Inc.
> 4500 Progress Blvd
> Louisville, KY  40218-5058
> Phone (502) 454-9013 ext 120
> email  DThomas@lpw-mdi.com
>
> +---
> | This is the JBA Software Users Mailing List!
> | To submit a new message send your mail to JBAUSERS-L@midrange.com.
> | To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
> | To unsubscribe from this list send email to JBAUSERS-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner: doug333@aol.com.
> +---

--
Pete Massiello
OS Solutions International
Phone: (203)-744-7854  Ext 11.
http://www.os-solutions.com
mailto:pmassiello@os-solutions.com


+---
| This is the JBA Software Users Mailing List!
| To submit a new message send your mail to JBAUSERS-L@midrange.com.
| To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
| To unsubscribe from this list send email to JBAUSERS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: doug333@aol.com.
+---