Re: Dates in DSPOBJD

[Mike.Barton@xxxxxxxxxxxx]

>When I perform a DSPOBJD to an *OUTFILE and then QRY the outfile hopefully
>sorting by creation date the date is in the format mmddyy. This obviously does
>not give me a correct sort order nor does it allow me to display the date in an
>acceptable DD/MM/YY format.
>
>Can I change this or do we have to live with it


You have to live with the format as defined in the DSPOBJD.

what u can do however is if u are creating a query (not just
doing a dynamic query with no actual query definition) is to
map the date around using SUBSTR operator in 'Define Result Fields'.

e.g.

Field       Expression                         Column Heading
CRTDD       SUBSTR(ODCDAT,3,2)
CRTMM       SUBSTR(ODCDAT,1,2)
CRTYY       SUBSTR(ODCDAT,5,2)
CRTDATE     ODCCEN || CRTYY || CRTMM || CRTDD


Then sort by CRTDATE (includes century bit)

Mike


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