i need to pass a date parameter(FROMDATE) from ASP to CRYSTAL now i cant seem to pass the date. So what i did is to convert the PARAMETER to a STRING.
The Problem is that in the REPORT the i am pulling records from SQL SERVER 7 and there is a datetime field matching the (FROMDATE)PARAMETER.SO
FROMDATE(string datatype)= date(datetime datatype )
HOW DO I DO A CONVERT in THE REPORT SELECTION.
PLEASE GIVE EXAMPLE CODE.
i am using SQL AS BACKEND
CRYSTAL 8.5
ASP
IIS
The Problem is that in the REPORT the i am pulling records from SQL SERVER 7 and there is a datetime field matching the (FROMDATE)PARAMETER.SO
FROMDATE(string datatype)= date(datetime datatype )
HOW DO I DO A CONVERT in THE REPORT SELECTION.
PLEASE GIVE EXAMPLE CODE.
i am using SQL AS BACKEND
CRYSTAL 8.5
ASP
IIS