All Forums Database
glory82 1 post Joined 03/15
12 Mar 2015
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.

dnoeth 4628 posts Joined 11/04
12 Mar 2015

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

Dieter

You must sign in to leave a comment.