Re: mdy date in query

[MacWheel99@xxxxxxx]

> From: wawrzaszeka@AUSTEEL.com (Angela Wawrzaszek)
>  
>  Can I write a opnqryf to select records out of a file,  where the date on
>  the file is stored in MDY  and I want to select dates out to process within
>  a range.  Since I can't sort the file by a logical - ie.   030100 through
>  030101 will not give me the correct records as will 000301 -  010301.
>  How can I get the correct selection?   I can not change the way the date is
>  stored on this file since it is populated there by many different programs.

I am a novice on OPNQRYF so I not know a lot of stuff.
Can you use a LOGICAL here to split the field up
In other words can we address the field by just going after the Y & against 
MD separately
Can we use wild cards %LIKE & select sub-groups

MacWheel99@aol.com (Alister Wm Macintyre) (Al Mac)
AS/400 Data Manager & Programmer for BPCS 405 CD Rel-02 mixed mode (twinax 
interactive & batch) @ http://www.cen-elec.com Central Industries of 
Indiana--->Quality manufacturer of wire harnesses and electrical 
sub-assemblies - fax # 812-424-6838

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