Inlcude past date in YY/MM/DD format

itclark · New User Joined: 10 Nov 2009 Posts: 3 Location: Edinburgh

I need to include current date minus 7 days in YY/MM/DD format in my output records.

I can use DATE1(/)-7 to get the correct date with 4 char year 2009/11/03

I can use DATE=(YMD/) to get current date with 2 char year 09/11/10, but I can't see a way to get this format for a date in the past.

Thanks, Ian

Frank Yaeger · Posted: Wed Nov 11, 2009 12:32 am

itclark · New User Joined: 10 Nov 2009 Posts: 3 Location: Edinburgh

Thanks for that Frank.
I wasn't specific enough with my original query as I only need to include the date on some of the output records, but I have used your suggestion to get the following which works perfectly.

Frank Yaeger · Posted: Wed Nov 11, 2009 11:28 pm

Note that you don't need an INREC and OUTREC statement to do this. You can do it with just one of them. For example:

itclark · New User Joined: 10 Nov 2009 Posts: 3 Location: Edinburgh

Thanks Frank - that's perfect.