How to add no of weeks to Date

Question

Hi In a date i want to add no of weeks . Thanks

Naimish Makwana · Answer

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 Singh · Answer

for sql DATEADD(week,2,CONVERT(datetime, yourDate))

Ali Benchaaban · Answer

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

Ramco Ramco · Answer

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 Swain · Answer

// 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);

Anandu G Nath · Answer

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

How to add no of weeks to Date

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (6)