subtract- datediff 52 weeks to a date

Database

subtract- datediff 52 weeks to a date

Hi, I write because I have a date (current_date) and I need substract 52 weeks and I dont know which function use.

 I think that with the syscalendar can do that but  I dont know how.

Thanks for your help.

1 REPLY
Senior Apprentice

Re: subtract- datediff 52 weeks to a date

52 weeks are 52*7 days, simply do current_date - 52*7