What is the correct format of passing Datetime parameter from VB

[anshul1966]

Hello
I have a input parameter of datetime type in my report called "FromDate" and I am trying to pass the value through my ocx control in Visual Basic. I have tried all the followin ways of sending but it is always givng me error "invalid parameter value". The formats I have tried are:
CrystalReport1.ParameterFields(0) = "FromDate;datetime(" & Format(l_s_Time, "YYYY;MM;DD;HH;MM;SS&quot & "true&quot

CrystalReport1.ParameterFields(0) = "FromDate;datetime(" & Format(l_s_Time, "YYYY,MM,DD,HH,MM,SS&quot & "true&quot

CrystalReport1.ParameterFields(0) = "FromDate;datetime('" & Format(l_s_Time, "YYYY/MM/DD HH:MM:SS AMPM&quot & "');true&quot

I hope somebody can help me with this.

Thanks

 

[MalcolmW]

The first parameter for Crystal Reports is
CrystalReport1.ParameterFields(1) = etc Malcolm Wynden
I'm for sale at

http://wynden.net

malcolm@wynden.net

 

[anshul1966]

Malcolm I have checked it and found that all crystal activeX control property arrays(like formula,parameterfields) are 0 based

 

[MalcolmW]

Whoops, I was thinking of something else. Are you using V7 by any chance? There is a bug with datetime parameters that wasn't fixed until V8 - see

http://support.crystaldecisions.com/kbase/c2006899.asp

Malcolm Wynden
I'm for sale at

http://wynden.net

malcolm@wynden.net