date range parameter passing?

[gabster]

Anyone knows what format should have a date range parameter passed from VB code to CR?

I am reading the dates from a XML file with the VB appp and then I pass them to CR.

Thanks you.

Gabi.

 

[papakula]

the format is "YYYY,MM,DD"

 

[gabster]

I get a type mismatch error when I try to use this date format.

CustomerReport.ParameterFields(1).AddCurrentValue "1968,12,21"

Thanks,
Gabi.

 

[jgaull1]

There are many bugs in crystal when using a date as a parameter. I've given up and now pass the date as a string.

I pass '01 30 2001' to my stored procedures and then use the SQL to add the slashes back in.

SELECT @AsOf = substring(@AsOf,1,2) + '/' + substring(@AsOf,4,2) + '/' + substring(@AsOf,7,4)

Hope this helps.

 

[gabster]

Thanks a lot!!!

I tried this and it worked:

CustomerReport.ParameterFields(1).AddCurrentValue CDate("1980,10,17&quot

Now the only question remains, how should I code in VB if I want to pass a date range

Gabi.

 

[chelseatech]

One format I've found works is
Date(2001,12,31)
As a string and the Word "Date" in that form... Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[gabster]

Thanks a lot for help!
Gabi.