How to calculate Interest between two dates ?

Question

Dear friends, Please help me , How to calculate Interest between two dates? suppose i have two datatimepicker in forms and i want to calculate interest from this dates in monthly interest. Please guide me if anybody have idea regarding this. Thanks....

Sujeet Suman · Answer

Nikunj in my first message I have marked calculated date with green color. So from there you will get total time period in date for your interest formula. int m_TimePeriodInDays = m_TimeSpan.Days; decimal m_PrincipalAmount; decimal m_InterestRate; decimal m_InterestAmount = ((m_PrincipalAmount * m_InterestRate) / 100); Please try once.

Nikunj Trivedi · Answer

Yes sir, i want to calculate interest logic in c# code, i want calculate interest on daily basis ( on total days) so, please sir guide me about this....

Sujeet Suman · Answer

Nikunj I think you should first find out the time period, then you can easily calculate interest as per the requirement. So please once try below code: DateTime m_FromDate = DateTimePicker01.Value;; DateTime m_ToDate = DateTimePicker02.Value; TimeSpan m_TimeSpan = m_ToDate - m_FromDate; int m_TimePeriodInDays = m_TimeSpan.Days; So now from here you can calculate interest easily either simple interest or compounding interest.

Santhakumar Munuswamy · Answer

Hi, If you want to calculate interest logic on c# code or sql server backend code for the above requirements.

How to calculate Interest between two dates ?

Answers (4)