I need to create exact one year from today

[ambadi007]

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

[Kurt_Bremser]

Have you tried

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

?

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

[Reeza · Accepted solution]

The last parameter for your intnx should be same. 

You also should use year and -1 interval. 

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

[Astounding]

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.