Skip to Content
0
Former Member
May 22, 2009 at 10:20 AM

Add time to a Date field

7 Views

Hi,

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

2009-05-22 11:17:52.000

year 2009

month may

date 22nd

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:

2009-05-22 12:17:52.000

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.

thanks

J

Sorry..I forgot to mention the DateField is a Date/Time field.

Edited by: James Knockler on May 22, 2009 12:21 PM