Gentlemen and ladies:
I have a form that passes values to a crystal report which has a prompt I
cant seem to get the variables to be passed as dates
here is the code
****************************************************************************
************************************************************
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>CIT/TFS Report Generator</title>
</head>
<body>
<DIV ALIGN="center"><H2>******Report Generator</H2></DIV>
<br>
<DIV ALIGN="center"><a
HREF="http://******/Crystal_Reports/inside_sales.rpt?user0=report&password0=
report&promptonrefresh=1&prompt0=date(2000,10,1)&prompt1=date(2000,10,19)"
TITLE="Inside Sales Activity Report" NAME="InsideSales">Inside Sales
Activity Report</a><BR>
</DIV>
<script lanquage="javascript">
function dateconvert(datestring){
if (datestring.length = 10)
{var stringM = datestring.substring(0,2)
var stringD = datestring.substring(3,2)
var stringY = datestring.substring(7,4)
var datestring = "date(" + stringY + "," + stringM + "," +
stringD + ")"}
}
</script>
<cfform name="form1" method="post"
action="http://********/Crystal_Reports/inside_sales.rpt?user0=report&passwo
rd0=report&promptonrefresh=1"&prompt0=#startdt#&prompt1=#enddt#">
<p align="center"><font color="#0000FF">Inside Sales Activity
Report</font></p>
<p>Please input a report starting date (mm/dd/yyyy)
<input type="text" name="startdt" value="10/9/2000" size="15"
onsubmit="dateconvert(startdt)">
<br>
and an ending date (mm/dd/yyyy)
<input type="text" name="enddt" size="15"
onsubmit="dateconvert(startdt)">
</p>
<p>
<input type="submit" name="Submit" value="Request Report">
<br>
</p>
</cfform>
</body>
</html>
****************************************************************************
*********************
could use some help
Dana E. Johnson
Sr. Web Developer
CIT
VTF/Technology Financing Services
[EMAIL PROTECTED]
(904) 620-7458
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]