Datediff function help!

zw^ · #1 (**permalink**) 10-17-03, 12:55

I have to date field
Startdate:
EndDate

How to use EndDate - StartDate????
Datediff function allow you to chose 1 date variable only
mine have to enter 2 date
how?????

zw^ · #2 (**permalink**) 10-17-03, 12:56

Quote:

Originally posted by zw^
I have to date field
Startdate:
EndDate

How to use EndDate - StartDate????
Datediff function allow you to chose 1 date variable only
mine have to enter 2 date
how?????

I have 2 date field
Startdate:
EndDate:

How to use EndDate - StartDate????
Datediff function allow you to chose 1 date variable only
mine have to enter 2 date
how?????

Seppuku · #3 (**permalink**) 10-17-03, 13:42

Quote:

Originally posted by zw^
I have 2 date field
Startdate:
EndDate:

How to use EndDate - StartDate????
Datediff function allow you to chose 1 date variable only
mine have to enter 2 date
how?????

DateDiff takes at least 3 parameters:

DateDiff(<datepart>, <date1>, <date2>)

Datepart is a character representing the part of the date to return the value a (YYYY = Year, Q = Quarter, M = Month, D = Day, W = Weekday, WW = Week, H = Hour, N = Minute, S = Second)

Date1 is the first date in the comparison.

Date2 is the second date in the comparison.

Code:

Response.Write DateDiff("YYYY", Now, "1/1/2000")

That should return "3" (if it's negative, just switch the dates)

zw^ · #4 (**permalink**) 10-17-03, 13:46

but mine have to enter the 2 date from the form because i have a form for people to submit their startdate and enddate.

Seppuku · #5 (**permalink**) 10-17-03, 13:50

Quote:

Originally posted by zw^
but mine have to enter the 2 date from the form because i have a form for people to submit their startdate and enddate.

Ok...

Code:

Dim dtStartDate, dtEndDate

dtStartDate = Request.Form("StartDate")
dtEndDate = Request.Form("EndDate")

Response.Write DateDiff("N", dtStartDate, dtEndDate)

That should show the numbers of minutes between the two dates...

zw^ · #6 (**permalink**) 10-17-03, 13:55

thanks Seppuku

zw^ · #7 (**permalink**) 10-17-03, 14:14

Seppuku can ask u if i wan to dispkay the price of the car wat should i do ?

i got 2 table rental and car.
rental contain the particulars of member and the car they chose to rent
car contain the car_no, model and daily rate.
how to retrieve daily rate from database??????

i write response.write(oRS("Daily Rate"))
but this error appear
ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name or ordinal.