calculate fine in asp.net by comparing two dates

venkimit...

SOLVED CLOSED ACTIVE ANSWERED
User: venkimithu
Posted: on Oct 09, 2012 09:19 AM
Forum: ASP.Net Web Forms
Answer: 1
Views: 5702

i am devloping library management system in asp.net C#. i want to calculate fine by comparing isuue date and return date. Here

Fine is calculated as:

Find the no of days between issue date and return date.

If no of days are greater than 10 then calculate fine using the formula given below

Fine=No. of Days * 10 Rs. (i.e 10 Rs fine per day)

Otherwise there will be no fine.

So i am inserting the record of isuue date in issue table (data type- Date in sql server)

so how i calculate by comparing the return date. please provide sagment of code for it.

Download FREE API for Word, Excel and PDF in ASP.Net

vinayak

0 2

Reply
ANSWER
User: vinayak
Replied: on Oct 09, 2012 09:34 AM
Report

try this in sql,

DECLARE @IssueDate date, @Days intSET @IssueDate = '2012-10-09 14:57:41.713'
SET @Days = DATEDIFF(DAY,'2012-09-20 14:57:41.713', GETDATE())
SELECT (CASE WHEN @Days > 11 THEN @Days * 10 ELSE 0 END) Fine

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

calculate fine in asp.net by comparing two dates

Company

Explore

Follow us

Contact Us