https://communities.sas.com/t5/SAS-Procedures/simple-intnx-and-date-formatting-question/m-p/63019#M17915 Investigate using the SAMEDAY argument to INTNX in your first assignment statement.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc. Mon, 01 Mar 2010 14:28:52 GMT sbb 2010-03-01T14:28:52Z https://communities.sas.com/t5/SAS-Procedures/simple-intnx-and-date-formatting-question/m-p/63018#M17914 I'm trying to create a new date which is exactly 18 years prior to a date currently held in my data.<BR /> <BR /> I've used the intnx function only to find it gives the first day of the year that occurred 18 years ago.<BR /> <BR /> I tried this but I'm getting no joy as I can't get the date format to be recognized... can anyone help?<BR /> <BR /> <BR /> dateminus18=intnx('year',start_date,-18);<BR /> <BR /> day=put(day(start_date),z2.);<BR /> month=put(month(start_date),z2.);<BR /> year=year(dateminus18);<BR /> <BR /> newdate=(compress(day||month||year));<BR /> newdate2=input(newdate,ddmmyyn8.); Mon, 01 Mar 2010 14:25:27 GMT https://communities.sas.com/t5/SAS-Procedures/simple-intnx-and-date-formatting-question/m-p/63018#M17914 deleted_user 2010-03-01T14:25:27Z https://communities.sas.com/t5/SAS-Procedures/simple-intnx-and-date-formatting-question/m-p/63019#M17915 Investigate using the SAMEDAY argument to INTNX in your first assignment statement.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc. Mon, 01 Mar 2010 14:28:52 GMT https://communities.sas.com/t5/SAS-Procedures/simple-intnx-and-date-formatting-question/m-p/63019#M17915 sbb 2010-03-01T14:28:52Z https://communities.sas.com/t5/SAS-Procedures/simple-intnx-and-date-formatting-question/m-p/63020#M17916 Awesome. I knew it would be simples. Mon, 01 Mar 2010 14:33:18 GMT https://communities.sas.com/t5/SAS-Procedures/simple-intnx-and-date-formatting-question/m-p/63020#M17916 deleted_user 2010-03-01T14:33:18Z https://communities.sas.com/t5/SAS-Procedures/simple-intnx-and-date-formatting-question/m-p/63021#M17917 Awesome. I knew it would be simples. Mon, 01 Mar 2010 14:33:23 GMT https://communities.sas.com/t5/SAS-Procedures/simple-intnx-and-date-formatting-question/m-p/63021#M17917 deleted_user 2010-03-01T14:33:23Z