Expert: Srini Nagarajan - 1/30/2008

Question
QUESTION: I try display multi page between start date and end date,while running 1st page diplay record click next page
date error ,how can sort out the error,am using ms access and asp

ANSWER: hi,

sorry for the delay in reply.

you need to convert the string to date format before pass as start date or end date.

-Srini

---------- FOLLOW-UP ----------

QUESTION: I format date string even 2nd page click(error messageMicrosoft JET Database Engine (0x80040E07)
Syntax error in date in query expression 'dep_date >= ## and dep_date <= ##'.)
strSQL = ("Select * From departure Where dep_date >= #" & date1 & "# and dep_date <= #" & date2 & "# order by dep_date")


Answer
hi

where the date1 and date2 to get filled?

in page 2 the date1 and date2 are blank so you are getting this error.

if you are getting the date value from request form or query string, you need to pass the date1 and date2 value when you goto page 2.

so the page 2 link should be like this

2
3
etc...

-srini