How to write datetime function for below statemen

Posted by Parcha under Sql Server on 10/28/2011 | Points: 10 | Views : 1034 | Status : [Member] | Replies : 1

scheduletime and siginingdate are two columns
Scheduletime <= (Contract Signing Date + 1 year - 1 day).

plz help me

Reply | Reply with Attachment

Posted by: SheoNarayan on: 10/28/2011 [Administrator] HonoraryPlatinum | Points: 25

0	It should be something like below DateTime contactDateTime = DateTime.Now; // will come from your database DateTime scheduleDateTime = contactDateTime.AddYears(1).AddDays(-1); Thanks Regards, Sheo Narayan http://www.dotnetfunda.com Parcha, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts