Need to add time to get new date

[shannonlp]

I have a report where I have a DateTime field and I need to add time to it to create another field.

Field 1 is Start Date Time.
Field 2 is a formula field where I converted seconds to hours. ({metric_hist.numeric_qty}/60)/60
Field 3 needs to be End Date Time. I need to add Field 1 and Field 2 to get the date and time which the job finished.

Can someone point me in the right direction to achieve this? I’m stuck…

Thanks in advance for any help.

 

[Madawc]

Try DateAdd, which includes an option to add time. Your HELP function should give you the details.

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP

 

[shannonlp]

Sorry for the late response - that worked. Thanks!