Hi Guys,

I am trying to convert a dateTime into hours or days.
Background:
I am creating a Case Incident report and want to see how long the ticket have been in the que since the create date until current date.

Thanks in advance.

TW

I haven't used Crystal Reports enough to know what functions it has for date and time. But I think all you need to know are the functions "Now()" and "DateDiff()".

If you can't put those directly into Crystal Reports, build a query in Access that uses them.

ElapsedHours: DateDiff("h",yourdatetimefield,Now())

ElapsedHours will contain a positive number that is the number of hours between the data in your date field and the computer's time. Of course if you reverse the fields, you'll get a negative number.

Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group
http://www.pnwadg.org

Thank you for your reply. I just found out that in Crystal you simply subtract the two fields and I will get the days different, then I can use the CTime function to convert to hours. Thank you very much.