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?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.