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/xhtml1/DTD/xhtml1-transitional.dtd">
<!--#include file="Connections/connCour
tList.asp"
-->
<%session.lcid=2057%>
<%
Dim rsDateRange
Dim rsDateRange_numRows
Set rsDateRange = Server.CreateObject("ADODB
.Recordset
")
rsDateRange.ActiveConnecti
on = MM_connCourtList_STRING
rsDateRange.Source = "SELECT * FROM CourtList"
rsDateRange.CursorType = 0
rsDateRange.CursorLocation
= 2
rsDateRange.LockType = 1
rsDateRange.Open()
rsDateRange_numRows = 0
%>
<html xmlns="
http://www.w3.org/1999/xhtml"
>
...
.....
<form name="formRange" id="formRange" method="post" action="printByDateResult.
asp">
<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>
Start Free Trial