What is the correct format of passing Datetime parameter from VB
What is the correct format of passing Datetime parameter from VB
(OP)
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
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
RE: What is the correct format of passing Datetime parameter from VB
CrystalReport1.ParameterFields(1) = etc
Malcolm Wynden
I'm for sale at http://wynden.net
malcolm@wynden.net
RE: What is the correct format of passing Datetime parameter from VB
RE: What is the correct format of passing Datetime parameter from VB
Malcolm Wynden
I'm for sale at http://wynden.net
malcolm@wynden.net