Please help me to modify the following to retrieve data from MS Access based on a range of date input (format: dd-mm-yyyy). The current result do not follow what I entered to the date field. e.g. 01-04-2004 will retrieve data for 4th Jan 2004.
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<?xml version="1.0" encoding="iso-8859-1"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtm
<!--#include file="Connections/connCour
<%session.lcid=2057%>
<%
Dim rsDateRange
Dim rsDateRange_numRows
Set rsDateRange = Server.CreateObject("ADODB
rsDateRange.ActiveConnecti
rsDateRange.Source = "SELECT * FROM CourtList"
rsDateRange.CursorType = 0
rsDateRange.CursorLocation
rsDateRange.LockType = 1
rsDateRange.Open()
rsDateRange_numRows = 0
%>
<html xmlns="http://www.w3.org/1
...
.....
<form name="formRange" id="formRange" method="post" action="printByDateResult.
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="16%" align="right">BETWEEN:</td
<td width="2%"> </td>
<td width="29%"><input name="dateFrom" type="text" id="dateFrom" /></td>
<td width="53%"> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td align="right">AND:</td>
<td> </td>
<td><input name="dateTo" type="text" id="dateTo2" /></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td>
<input type="submit" name="Submit" value="Submit" /></td>
<td> </td>
</tr>
</table>
</form>
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
There is always trouble with dateformats.
I have come to this practice:
- for client input in forms i don't use <input type="text">, but either a calendar (date-picker) or some dropdown boxes.
- at the server, when communicating with the database, i use dateformat yyyy/mm/dd (because that will be interpreted by all databases correctly.
Would suggect using drop-downs for the date. Consider the routine below. You can call it as
DateDrop ("FromDate",Date,1970,Year
and
DateDrop ("ToDate",Date,1970,Year(D
Then at receiving page...
FromDate=DateSerial(Reques
Sub DateDrop(CompName,DefVal,Y
Dim iCnt, iDay, iMonth, iYear
iDay=Day(DefVal)
iMonth=Month(DefVal)
iYear=Year(DefVal)
'Day
%><select name="<%=CompName%>_dd"><%
For iCnt=1 to 31
%> <option value="<%=Right("0" & iCnt,2)%>"<%If iCnt=iDay Then%> selected<%End If%>><%=iCnt%></option><%
Next
%></select><%
'Month
%><select name="<%=CompName%>_mm"><%
For iCnt=1 to 12
%> <option value="<%=iCnt%>"<%If iCnt=iMonth Then%> selected<%End If%>><%=MonthName(iCnt,Tru
Next
%></select><%
'Year
%><select name="<%=CompName%>_yyyy">
For iCnt=YearStart to YearEnd
%> <option value="<%=iCnt%>"<%If iCnt=iYear Then%> selected<%End If%>><%=iCnt%></option><%
Next
%></select><%
End Sub
Business Accounts
Answer for Membership
by: Makr_Watson27Posted on 2004-03-24 at 00:18:03ID: 10665210
There really is no quick and easy answer to your problem, however if you can be certain that your users will only enter in the form of dd-mm-yyyy then you can convert that into a Access Date Format of mm-dd-yyyy by using the following:
dateFrom = Request.Form("dateFrom")
convertedDateFrom = "#" & Mid(dateFrom, 4,2) & "-" & Left(dateFrom, 2) & "-" & Right(dateFrom, 4) & "#"
If however you cannot be certain of date formats being entered by the user then have a look at the following .NET date control
http://www.peterblum.com/D