Solved
Contributor
Posts: 68

# I need to create exact one year from today

Hi Team,

I want to create an year value and it should be exact one year from today irrespective of leap year or what ever I have tried the below code

test=intnx('month',today(),-12,'B');

But it was not giving exact exact one year difference it was giving 01-May-2015 but i need 12-May-2015 ie if the job is running today it should calculate exact one year difference.

Thanks

Manesh

Accepted Solutions
Solution
‎05-12-2016 10:40 AM
Super User
Posts: 23,773

## Re: I need to create exact one year from today

The last parameter for your intnx should be same.

You also should use year and -1 interval.

Intns('yeat', today(), -1, 's')

All Replies
Super User
Posts: 10,280

## Re: I need to create exact one year from today

Have you tried

``test = intnx('year',today(),-1);``

?

If yes, and it did not give you your wanted result, what was the difference?

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Solution
‎05-12-2016 10:40 AM
Super User
Posts: 23,773

## Re: I need to create exact one year from today

The last parameter for your intnx should be same.

You also should use year and -1 interval.

Intns('yeat', today(), -1, 's')

Super User
Posts: 6,785

## Re: I need to create exact one year from today

[ Edited ]

Also, you may want to compare these two to see if they give you the same results for leap years:

intnx('year', today(), -1, 'S')

intnx('month', today(), -12, 'S')

it's possible they are equivalent, but check for a Feb 28, Feb29, and March 1 date to see what you get.

***

I found time to test them ... they generate the same result.

🔒 This topic is solved and locked.