Loading

my question related to sqlserver date functioan

my question related to sqlserver date functioan

anuj singh

11y829Visual Basic .NET

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 ASP,NET AND SQL SERVER AND C# LANGUAGE.

3 Replies

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

Raja T11y ago
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 Susaimichael11y ago
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(day,45,'2015-11-06') AS NextEMIDate

"DateAdd" function is the builtin function in SQLServer.

Hope this helps!
Francis Susaimichael11y ago
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!