Getdate

[#1]

Hi,

I want to make a date that is 12 month back and 36 month back.

If I write 12 as below I get -12 days.

Instead I want to remake 12 as month. How do I do that?

getdate()-12 as 12_month_back__date,

/Julia

[Gysbert_Wassenaar · Accepted solution]

addmonths(today(),-12)  as 12_month_back_date

addyears(today(),-3) as 3_year_back_date

[Anonymous]

Hi Peter,

you can use the function

addmonth(max(Date),-12)

Regards

Arun Reddy

[#4]

Thanks!

/Julia