What is the correct format of passing Datetime parameter from VB

Question

What is the correct format of passing Datetime parameter from VB

anshul1966 (Programmer)

(OP)

25 May 01 09:03

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") & ");true")

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

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

I hope somebody can help me with this.

Thanks

MalcolmW (Programmer) · Answer 1 · 2001-05-25 13:03:14

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 (Programmer) · Answer 2 · 2001-05-25 13:12:22

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

MalcolmW (Programmer) · Answer 3 · 2001-05-25 13:27:04

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

Come Join Us!

Posting Guidelines

What is the correct format of passing Datetime parameter from VB