Help adding century to YYMMDD date

leedtech · New User Joined: 14 Dec 2006 Posts: 6 Location: Ohio

I am trying to add a century to a date in YYMMDD format. I want the century to be determined by using the current year as the window (i.e. current year or less will be filled with 20 as century, otherwise 19).

I was able to use Y2PAST=100 to get the century to populate, however current year fills with 19 instead of 20.

Frank Yaeger · Posted: Fri Apr 29, 2011 9:05 pm

leedtech · New User Joined: 14 Dec 2006 Posts: 6 Location: Ohio

Frank,

That is the desired result.

Lee

Frank Yaeger · Posted: Sat Apr 30, 2011 1:17 am

You could use Y2PAST=1912, but then you'd have to add 1 each year.

Or you could use Y2PAST=100 with the following DFSORT control statements which will fix the current year:

leedtech · New User Joined: 14 Dec 2006 Posts: 6 Location: Ohio

Frank,

Sorry for delayed response.

I just wanted to thank you for your help.

Lee