[marckiestar]

Hi! I'm working on a Library System for my Project! This is the case, I wanted to know what is the syntax on how to get the difference of two dates, to be exact, the total number o days between the two dates.

[b]I am thinking of this one, DiffDate(Interval as String,Date1,Date2)

I don't really know how to use it, for example, I have two dates:

BorrowDate = 8/02/2008
ReturnDate = 10/18/2008

an you give me the syntax for this? I wanted that it will return the total number of days between these two dates.
Please give examples.

[jjsaw5]

[rules][/rules]

[marckiestar]

jjsaw5, on 15 Oct, 2008 - 05:03 AM, said:

[rules][/rules]

Hi!

The code is quite long, Im now working on the process of returning books, I'm done with Borrower Registration, Payment for registration, and activation of the three library cards.

I just wanted to know the syntax on how to subtract two dates, so that I would be able to compute the necessary penalty for the excess days.

It doesn't mean that I don't do the coding, I just want the syntax, so that I would know. Just examples.

[jjsaw5]

Have you tired searching the internet for these examples? I'm sure there are plenty of examples on the net.