Converting a string to a datetime

[morfeus]

Dim s As String
s = "2000, 12, 1"
formula=CDateTime (s)

This one works just fine, return the datetime and time is naturally 00:00:00. But as the manuals say that the DateTime syntax is DateTime (YYYY, MM, DD, HH, MM, SS) or one can give a string that holds the DateTime in the same way.

Dim s As String
s = "2000, 12, 1, 12,10,0"
formula=CDateTime (s)

Well when I add the time the formula fails, saying :"BAd date-time format string" erm i have read the users giude a dozen time and i still belive that my syntax is correct but crystalreport fails or can someone state otherwise.

 

[morfeus]

well found out about the us time syntax.... crystal reports manuals are nice that they speak of many ways to do this but that only one works actuall... great job by the author