Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

What is the correct format of passing Datetime parameter from VB

Status
Not open for further replies.
anshul1966

anshul1966

Programmer
Joined
May 25, 2001
Messages
5
Location
US
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
 
Sort by date Sort by votes
The first parameter for Crystal Reports is
CrystalReport1.ParameterFields(1) = etc Malcolm Wynden
I'm for sale at malcolm@wynden.net
 
Upvote 0 Downvote
Malcolm I have checked it and found that all crystal activeX control property arrays(like formula,parameterfields) are 0 based
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

tlbrown88
  • Locked
  • Question Question
How does one get the results of a Calculation (SharedVar) on the same line as the Sub Report?
Replies
4
Views
971
tlbrown88
tlbrown88
Corinne30
  • Locked
  • Question Question
Running total based on beginning parameter value
Replies
0
Views
359
Corinne30
Corinne30
Corinne30
  • Locked
  • Question Question
Running total based on beginning parameter value
Replies
0
Views
362
Corinne30
Corinne30
B
  • Locked
  • Question Question
Difference of a field between 2 variable dates
Replies
1
Views
623
hilfy
hilfy
socalvelo
  • Locked
  • Question Question
Extract Phone Numbers from Text Field
Replies
0
Views
711
socalvelo
socalvelo

Part and Inventory Search

Sponsor

Back
Top