Re: SQL list *OUTFILE of DSPOBJD by date

[CRPence <CRPbottle@xxxxxxxxx>]

  Unless something has changed, the DSPOBJD is unaffected by the job's 
Date Format for all of its /date-like/ values except the date of the 
inquiry [i.e. the date the DSPOBJD was performed].  See the output from 
DSPFFD QSYS/QADSPOBJ which in my recollection has always showed for 
every ODxDAT column following a ODxCEN column, that the date format is 
always MMDDYY; i.e.:

    Field text  . . . . . . . . . :  ??whatever?? date (MMDDYY)

Regards, Chuck

On 11 Apr 2013 12:22, Stone, Joel wrote:
> Is it possible to ensure this functions properly even if a user does
> a CHGJOB DATFMT(*YMD) and then uses the SQL suggested below?
>
> Problem is that the SQL is expecting the date to be a certain format
> MMDDYY or whatever. If the job format is changed to YYMMDD as is
> more common in IT, then the SQL fails.