Need a Days Elapsed Formula 1

[JHear1]

I want to create a report that shows all tickets older than 30 days. I assumed that I would subtract the date the ticket was logged from the current date, but have had no luck. This is the formula that i have tried.
Whileprintingrecords;
Datevar Open:=Date({CallLog.RecvdDate});
Datevar Current:=Date(CurrentDate);
NumberVar Days:=(Current-Open);
If(Days)>= 30 Then 1 else 0

This is reporting from the HEAT 5.01 Problem Management Database.
Thanks,
Jeff

 

[MalcolmW]

What values do you see for Days? Malcolm Wynden
I'm for sale at

http://wynden.net

malcolm@wynden.net

 

[JHear1]

I am using Crystal 7.
The dates in the CallLog.RecvdDate = 2001-05-11
Print Date = 5/11/2001
Date & Time Last Modified = 989,582,208
Is what I have to work with so far.
Thank You for your reply.
Jeff

 

[MalcolmW]

I was actually referring to the variable Days in your formula - what value to have for Days? Malcolm Wynden
I'm for sale at

http://wynden.net

malcolm@wynden.net

 

[kenhamady]

Is your receive date a string? In V7, the DATE function won't convert a string to a date.

Also, in V7 you don't need to (and can't) put CurrentDate into the Date Function. It is already a date. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[JHear1]

From your questions, I think that my attempt at a formula is not correct. I don't have a value set for "days" as that is what I'm trying to calculate. The date formats that the system is providing is as stated above. I may need to go to Crystal 8 to get this to work?

 

[kenhamady]

>>The date formats that the system is providing is as stated above

What I need to know is the datatype, which is defined in the database. Right-click on the field and select "Browse-Data" to check the data type. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[JHear1]

Thanks for the step by step, I can be dense.
Answers as follows;
CallLog.RecvdDate = 2001-05-11 (STRING)
Print Date = 5/11/2001 (Field Insert - No Browse)
Date & Time Last Modified = 989,582,208 (NUMBER)
Thanks,
Jeff

 

[kenhamady]

Try the following:

if CurrentDate - DTSToDateTime ({CallLog.RecvdDate})>30
then 1
else 0

the DTS functions are under "Additional". Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[JHear1]

Thank You. That worked perfect. You are the man!

 

[ecugrad]

I have two DateTime fields CREATETIME & TERMINATION what I'm trying to do is to subtract the TERMINATION from the CREATETIME to get my processtime from my queue. My problem is that I don't want the time period from 5:00PM to 8:00AM to be included in my calculation.

Example: Createtime 5/14/01 3:00 PM Temination 5/15/01 10:00 AM Total Process Time 19hrs. I would like this to be 4hrs of processing time.

I am using CR8..

Thanks for any help,

Mike

 

[kenhamady]

Check the FAQ section of the General CR forum. I have a FAQ on common formulas that has a formula that does what you want. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)