Re: Date conversion technique in QUERY

[Larry Bolhuis <lbolhui@xxxxxxx>]

Carl,

 The trick we use is to create a small PF that has the date in several formats,
MMDDYY, YYMMDD, CCYYMMDD, Month DD YYYY, etc, and included our fiscal month and
year.  Populate the file with several years worth of data with a simple RPG
program. Then in the query you can now include this file and pick any format you
want.  It also helped select records for a particular fiscal period.

  HTH

 - Larry

Carl Galgano wrote:
> 
> anyone have a quick and dirty way to convert a date (6,0) in a YYMMDD format
> to a MMDDYY format for printing in a Query?  I know I can multiply by
> 100.0001, however Query thinks it knows better and won't let you chop off
> the left most 2 significant digits, which makes this technique not work.  (I
> get the dreaded +++++++++ as the output for this field).
> Surely someone has solved this little problem.
> TIA,
> Carl
> Carl Galgano
> EDI Consulting Services, Inc.
> 540 Powder Springs Street
> Suite C19
> Marietta, GA  30064
> 770-422-2995
> mailto: cgalgano@ediconsulting.com
> http://www.ediconsulting.com
> EDI, Communications and AS400 Technical Consulting
> 
>   
>--------------------------------------------------------------------------------
> 
>   Carl J. Galgano <cgalgano@ediconsulting.com>
>   EDI Consulting Services, Inc.
> 
>   Carl J. Galgano
>   EDI Consulting Services, Inc.                          
><cgalgano@ediconsulting.com>
>   540 Powder Springs Street Suite C19;Marietta;GA;30064  Work Voice: 
>770-422-2995
>                                                          Voice Pager: 
>770-839-8168
>                                                          Work Fax: 
>770-425-8391
>   Additional Information:
>   Version        2.1
>   Last Name      Galgano
>   First Name     Carl
>   Additional NameJ.
>   Label Work     540 Powder Springs Street Suite C19 Marietta, GA 30064
>   Revision       19990209T114331Z

-- 
Larry Bolhuis         |
Arbor Solutions, Inc  | Two rules to success in life:
(616) 451-2500        | 1. Never tell people everything you know.
lbolhui@ibm.net       |
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---