Search results for query: *

I'm a little confused. All i want is a list of technical calls older than 3 working days (monday thru to friday)

they are all DATE Once again thanks for your help

the test formula is asking for a date between '' else if {tblTechnicalCallLog.CallDate} ='<asking for a date here>' then 'Empty' i cant seem to win on this one

The error occured in the new test formula too The field {tblTechnicalCallLog.CallDate} always has data.

sorry it point to just above WHILE Added > Add "the remaining text does not appear to be part of this formula" error is occcuring on that line" the same occurs if i do a datevalue({tblTechnicalCallLog.CallDate});

I got the message again.. "the remaining test does not appear to be part of this formula" error is occcuring on that line

I get the following error. "A number, currency amount, boolean or string is expected here." I copied the formula from Ken Hamady so I'm unsure why it is not working

Thanks for the replies guys, I have replaced the field with {tblTechnicalCallLog.CallDate}. It is in the datetime format

WhileReadingRecords; DateVar Array Holidays; DateVar Target:={@StartDate}; //Put your field name in here NumberVar Add:= -3; // Put in the number of days to subtract (a negative number) NumberVar Added := 0; WHILE Added > Add Do (target := target -1; if dayofweek (target) in 2 to 6 and...

Thank You for youe help but... while added > add is not working. "the remaining test does not appear to be part of this formula" error is occcuring on that line. Thanks Thomas

Hi to everyone. My name is Thomas This is my first post and I am not a Crystal expert. I work for a IT company and have to work the support help desk during the the week. If a call goes on over 3 days it has be highlighted. I have written a Crystal report to display calls open older than 3...