diff between dates

[jobillborf]

Hi, I have two date time fields

1) problem_date 01/03/04 07:15 am
2) resolved_date 01/04/04 09:30 am



I would like the difference to be the total number of hours the remainder not in minutes but with a decimal point.

In this example the result would be 26.25 hours .25 represent 15 minutes.

Thank you for your help.

 

[bdreed35]

Try this:

datediff("n",{table.problem_date},{table.resolved_date)/60;

Make sure that you format it on the report to show 2 decimal places.

~Brian

 

[jobillborf]

Thank you Brian. It works

I will have another post up soon.

It will deal with datediff and the amount of days.

 

[bdreed35]

Take a look at the DateDiff function in the Help files. You can probably figure it out by reading the topic page there.

~Brian