I have a problem where in my Database I have a date & time field. when i query this field in mysql, it looks like this
time 11:17 (52.000 seconds)
I want to be able to add an hour to this field in Crystal Reports and output it on a report. So the output would look something like:
How would I go about doing this.
I tried doing a ToText() + '2009-05-22 12:17:52.000' but it just appends it to the end of the rigonal date.
Sorry..I forgot to mention the DateField is a Date/Time field.
Edited by: James Knockler on May 22, 2009 12:21 PM