Re: Dates in DSPOBJD

[Rob Berendt <rob@xxxxxxxxx>]

                             Define Result Fields                             
                                                                              
Type definitions using field names or constants and operators, press Enter.   
  Operators:  +, -, *, /, SUBSTR, ||, DATE...                                 
                                                                              
Field       Expression                         Column Heading        Len   Dec
CHANGEDATE  DATE(SUBSTR(odldat,1,2)||'/'||                                    
                 substr(odldat,3,2)||'/'||                                    
                 substr(odldat,5,2))                                          
                                                                              




Chris.Chambers@v2music.com on 06/07/2000 10:39:55 AM
Please respond to MIDRANGE-L@midrange.com@Internet
To:     midrange-l@midrange.com@Internet
cc:      
Fax to: 
Subject:        Dates in DSPOBJD

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


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