Converting STRING (date as string) to a DATE value 1

[Adamxxx]

Am using a database which allocates time buckets as STRING values. Would like to somehow convert the values in this field to date values so i can then group by time in what ever interval i want using the group expert. The database (which I cant control) records info in 15 minute intervals. I would like to create a report in 1 hour intervals. It seems easy to convert a date to a string but much more difficult to convert a string to a date. Can anyone help?

 

[MalcolmW]

Depending on your version of Crystal Reports, you can use the DateTimeValue() function. The online help has the syntax details. Malcolm

 

[Adamxxx]

We use crystal reports 6 which evidently doesnt have this function. What other options might exist? Thanks!

 

[kenhamady]

What does a sample time string look like? ie, how is it stored? Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[Adamxxx]

stored as 22 character string:

example:

1996/12/08 23:59:00:00

 

[kenhamady]

Look in your additional functions for a function called DTSToDateTime(). This will work with your string if you have it. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)