Increment date

Question

HI everyone string enddate = dgv.CurrentRow.Cells[ Date ].Value.ToString(); I have taken date from data grid view as given above. Now i need to write a update query where i need to update the enddate by 1 month and 15 days according to the condition. Therefore could you please tell me how to increment the date.

Pravin More · Answer

Hi Ruchi  do this by way.... enddate=Convert.TodateTime(enddate); enddate.AddMonths(1); enddate.AddDays(15); i hope this will solve ur problem. Thanx pravin

Pravin More · Answer

HI try this String newdt=enddate.toString() newdt = String .Format( {0:MM/dd/yy}  newdt); Thanx Pravin

Ruchi R · Answer

Thanks for the reply can you do me one more favor please. If i need to convert the enddate into MM-dd-yyyy format and remove the time from it. How can i do that?

Mamta M · Answer

Your requirement is not very clear...do you mean to update end date by 1 month or 15 days depending upon the condition or do you want to update by 1 month and 15 days (which would be 45 days if the month has 30 days)? This is not clear...I mean do you want a conditional update for either 1 month or 15 days or just 1 update? If it's only 1 update here's the code: Assuming you have converted your date from string enddate to a DateTime value dt: dt = dt.AddMonths(1); then followed by dt = dt.AddDays(15);