Re: Dates in DSPOBJD

[Pete Massiello <pmassiello@xxxxxxxxxxxxxxxx>]

Ops, this message got away from me, I hit the enter key by accident.

Use the century field as well, and then convert the existing field by using a 
result
field into YYMMDD Then you can use both fields to sort with.  You could 
concatenate
the century field, to the new date field, but it will not look right when 
displayed.

    Sorry about the quick fingers

    Pete

Pete Massiello wrote:

> Use the century field as well.
>
> Chris.Chambers@v2music.com wrote:
>
> > 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
> >
> > (QDATE is already DDMMYY)
> >
> > Regards,
> >
> > Chris
> >
> > __________________________________________
> >
> > Visit http://www.v2music.com for the latest artist news, videos,
> > tour dates, competitions and much more.
> >
> > +---
> > | 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
> > +---
>
> --
> Pete Massiello
> OS Solutions International
> Phone: (203)-744-7854  Ext 11.
> http://www.os-solutions.com
> mailto:pmassiello@os-solutions.com
>
> +---
> | 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
> +---

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


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