RE: Date conversion technique in QUERY

Carl,

On the define result fields screen in the query definition.  The field from
the database is YYMMDD and the result is MMDDYY to print on the report.
This works nicely.  

 Field       Expression                        
 DATEC       digits(YYMMDD)                    
                                             
 MMDDYY      substr(datec,3,2)||substr(datec,5 
             ,2)||substr(datec,1,2)            
                                              

James Bartrug 
TSSI
jbartrug@tssint.com


-----Original Message-----
From: Carl Galgano [mailto:cgalgano@ediconsulting.com]
Sent: Tuesday, February 09, 1999 5:44 AM
To: Midrange List
Subject: Date conversion technique in QUERY


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

+---
| 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
+---