String to Date Conversion

[oanion]

SQL Server 2000
Crystal Entrprise
ASP Web Pages.


I’m trying to accomplish the following:

1.Accept 2 string dates from input from an ASP page

2.Convert the 2 string date parameters to a date type in Crystal

3.use the 2 converted dates to evaluate records between the 2 dates.

Currently, I’m having trouble converting the string date into a date datatype in Crystal. The string date parameters passed are in the following format MM/DD/YYY. I’ve attempted convert the string date to a date datatype in Crystal. Is there another date format I should tell the programmer to pass to Crystal from the ASP web page?

 

[TedLiu]

Hi,

Yuo can use Cdate(parameter_stringdate) in your selection formula.

Ted