hi scott
ya i used dayadd function
i am able to increase the year but one day before ..how to do that.. ..SELECT DATEADD(Year, 1, 20-10-2007) AS NewDate
it should display 19-10-2008
hi scott
ya i used dayadd function
i am able to increase the year but one day before ..how to do that.. ..SELECT DATEADD(Year, 1, 20-10-2007) AS NewDate
it should display 19-10-2008
Last edited by Aussiebear; 03-27-2025 at 12:39 PM.
Posting Permissions
Reply With Quote