Re: Date conversion

from: "Howie, Bill" <BHowie@xxxxxxxxxxxxxxxx>
subject: Date conversion

Hello all,

I have what is surely a simple question but I can't seem to find an answer
to it. I have a work file that I've created that contains the output of
the DSPOBJD command for a particular library. This file has the field
ODUDAT, which is the date last used field. It's a character field in the
MMDDYY format. I'm using Run SQL Scripts in ACS to then query this file,
but I'd like to convert this date to YYYYMMDD format so that I can order
the query results by the most recent date. The only way I can find that
comes close to working so far is just to substring the ODUDAT field into
the month, day, and year portions and then play with it that way. I'm sure
there's a more elegant method that will just yield a YYYYMMDD field.
Thoughts?

Any ideas on this would be greatly appreciated. Thanks!