simple intnx and date formatting question...

[deleted_user]

I'm trying to create a new date which is exactly 18 years prior to a date currently held in my data.

I've used the intnx function only to find it gives the first day of the year that occurred 18 years ago.

I tried this but I'm getting no joy as I can't get the date format to be recognized... can anyone help?


dateminus18=intnx('year',start_date,-18);

day=put(day(start_date),z2.);
month=put(month(start_date),z2.);
year=year(dateminus18);

newdate=(compress(day||month||year));
newdate2=input(newdate,ddmmyyn8.);

[sbb]

Investigate using the SAMEDAY argument to INTNX in your first assignment statement.

Scott Barry
SBBWorks, Inc.

[deleted_user]

Awesome. I knew it would be simples.

[deleted_user]

Awesome. I knew it would be simples.