my question related to sqlserver date functioan

Question

sir i making property website so...first we sale plot plot is sale full payment and laon.... one plot is cost 10000 any person want to by this plot by loan...so we take money ..through (EMI) .......................................................LIKE THIS............... CUSTOMER NAME..............................ANUJ CUSTOMER ID......................................1 CUSTOMER GIVE AMOUNT ...............10000.... CUSTOMER FIRST EMI DATE..............(6-11-2015) .............................................................................................. NOW WE WANT NEXT MONTH DUE EMI DATE.. BUT PROBLEM IS MONTH DAYS ..SOME MONTH IS 30 DAYS SOME 31 AND FEB IS 28 OR 29 SHO HOW CAN CALCULATE DUE EMI DATE FOR NEXT MONTH.. I USING ASPNET AND SQL SERVER AND C# LANGUAGE.

Francis · Answer

Sorry i didn't see the subject of your post. According to that i guess you want to achieve this in SQL Server if so you can try with this: SELECT DATEADD(day45'2015-11-06') AS NextEMIDate DateAdd function is the builtin function in SQLServer. Hope this helps!

Raja T · Answer

Hi Anuj As per my understanding about your requirement you need every month 6th you send notification am i right? So you can check like below query SELECT YEAR(getdate()) as year MONTH(getdate()) as month DAY(getdate()) as day; here you check month and day. So you need write one store procedure (SP) for very month 6th send notification to customer EMI due day is today. Schedule/Job in SQL Server

Francis · Answer

HOW CAN CALCULATE DUE EMI DATE FOR NEXT MONTH.. Sure. In C# you could use the below code: DateTime currentEMIDate = new DateTime(2015 11 6); // Add 30 Days to the current EMI Date DateTime NextEMIDate= currentEMIDate.AddDays(30); Console.WriteLine(Next EMI:  + NextEMIDate); If you need any help let me know! Hope this helps!