formula help

[mgossman]

I'm calculating total seconds using the following formula. The formula is working fine. What I'd like to do is set a maximum value of 599, that is, if the result is > 599, I want to set it to 599. Can anyone help?

//calculate incident first on scene response time
//date difference in seconds
Numbervar SecondsBetweenDate := (Date ({incident.arrivaldate}) -
Date ({incident.alarmdate})) * 86400;
//time difference in seconds
Numbervar SecondsBetweenTime := (Time ({incident.arrivaldate}) - Time (0,0,0)) -
(Time({incident.alarmdate}) - Time(0,0,0));
//add date difference and time difference
SecondsBetweenDate + SecondsBetweenTime

 

[kenhamady]

Why mess with a working formula. I would just create a second formula that said:

If {@formula} > 599
then 599
else {@formula} Ken Hamady

http://www.kenhamady.com/

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