Click to See Complete Forum and Search --> : Asp code


anubaskppk
March 4th, 2006, 10:17 AM
Hi,

A part of my project involves ,getting, From Date and To Date and to display user names whose registered date comes inbetween the two given dates. I'm following one way, where i seperate day, month and year from the two dates and check with them. But this method is not retreiving correct results. I tried even with this code, rs(userregdate)>=(fromdate) and rs(userregdate)<=(todate). But its showing a datatype mismatch error. Please somebody help me, I'm in dire need. I've to complete the project within 2 days, Please help me.

l0_0l
March 4th, 2006, 03:59 PM
Its hard to understand if you don't ******** whetherthat is just simple computation over date difference right on the script itself or data taken from database or or or or or alot,
you post th e whole script, some people may read line by line to check it up for you.
mayb some mistakes u made undiscovered by yourself somewhere inthe script.
One IN one OUT of course create time difference

degsy
March 7th, 2006, 06:34 AM
Response.Write your variables to make sure they are in the correct format. You could also use some of the VB conversion functions to make sure the variables are in the same format.