Subtract exactly one year from a date

[NewUsrStat]

Hi guys, I have a date like this: 01JUL2021. How can I get 01JUL2020? I need to subtract exactly one year.

I tried the following but without success. The date is no more "01JUL"

my_new_date = INTNX('YEAR',mydate,-1);

Thank you in advance

Best

[FreelanceReinh · Accepted solution]

Hi @NewUsrStat,

Use 's' (the "SAME alignment") in the fourth argument of the INTNX function:

my_new_date = INTNX('YEAR',mydate,-1,'s');

The default is 'b' (beginning).

[PaigeMiller]

---

@NewUsrStat wrote:

Hi guys, I have a date like this: 01JUL2021. How can I get 01JUL2020? I need to subtract exactly one year.

I tried the following but without success. The date is no more "01JUL"

my_new_date = INTNX('YEAR',mydate,-1);

---

So just to be 100% complete, when a date is 01JUL2021 in a numeric variable, then @FreelanceReinh has the solution. But if the date of 01JUL2021 is in a character variable (is it? you don't tell us) then that won't work. Then you want this:

one_year_ago = intnx('year',input(char_date_variable_name,date9.),-1,'s');

[Kurt_Bremser]

Maxim 1: Read the Documentation

INTNX Function: Alignment