How to add no of weeks to Date

Ramco Ramco

In a date i want to add no of weeks .

Thanks

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

SELECT GETDATE() 'Today-',DATEADD(week,2,GETDATE()) 'Today + 2 Weeks'

SELECT GETDATE() 'Today-',DATEADD(MM,2,GETDATE()) 'Today + 2 month'
SELECT GETDATE() 'Today-',DATEADD(YY,2,GETDATE()) 'Today + 2 Year'

Today-	Today + 2 Weeks
2023-12-27 12:48:30.390	2024-01-10 12:48:30.390

Today-	Today + 2 month
2023-12-27 12:48:30.390	2024-02-27 12:48:30.390

Ramco Ramco3y ago

Hi Naimish

In below code i want to add 2 weeks to vsessiondate

foreach (var colum in Result)
{
    DateTime? vSessionDate = null;
    Session Rec = bALSessionc.GetDetail(colum.Session);
    vSessionDate = Rec.SessionDate;
}

Thanks

Rajkiran Swain3y ago
// Create a new date object
let date = new Date();

// Add 4 weeks (28 days) to the date object
date.setDate(date.getDate() + 28);

// Output the new date
console.log(date);

+3

Naimish Makwana3y ago

Hello Ramco,

Use this.

DateTime date = DateTime.Now; // Replace with your desired date
int numWeeks = 4; // Replace with the number of weeks you want to add

DateTime newDate = date.AddDays(numWeeks * 7); // Add the number of days equivalent to the number of weeks

Thanks

Naimish Makwana

Sachin Singh3y ago
for sql
```
DATEADD(week,2,CONVERT(datetime, yourDate))
```
+3
Ali Benchaaban3y ago
Hello Ramco,

You can use DATEADD() function to add weeks to DateTime in Sql Server. DATEADD() functions first parameter value can be week or wk or ww, all will return the same result.
```
SELECT GETDATE() 'Today',DATEADD(week,2,GETDATE()) 'Today + 2 Weeks'
SELECT GETDATE() 'Today',DATEADD(wk,2,GETDATE()) 'Today + 2 weeks'
SELECT GETDATE() 'Today',DATEADD(ww,2,GETDATE()) 'Today + 2 Weeks'
```
*

BENCHAABAN Ali
+3