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.
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.