Search results for query: *

Excellent. Thank you very much. Sarah

Thanks for that - it says there are too many arguements given to the function ???? Not sure what to do really.

Thanks very much for your advice The formula as follows returns the error - remaining text does not appear to be part of the formula. Time (ToNumber (Mid ( ({Clinical_record_N.Time_Logged}) , 5 ,4 ) ) ), ToNumber ( (Mid ( ({Clinical_record_N.Time_Logged}) , 3 ,2 ) ) ), ToNumber (...

I have Crystal 8.5 and am trying to select records between certain times. Unfortunately the field is a string. I have tested the field to see if it can be converted to a time with Istime ({field}) but this returns false. I have created the following formula to break the time up but I can't...

Thanks. When I put "YYYY, MM, DD" as the first argument in date diff I get an error "Argument #1 of date diff is out of date range". I can get them separately but not together which I what I am trying to do. I am quite a novice so please forgive me if it is simple.

This is my formula datediff ("d", {Referral_details.Date_Referred}, {Patient.Date_Death}) Example data: Ref date 4.4.2000 RIP date 13/7/2000 result: 100 Ref date 17/4/2000 RIP date 12/5/2000 result: 25 Ref date 23/6/2000 RIP date 3/1/2004 result: 1,289 I would like the return result to show...

On looking at it again, it did return the correct number (the field was partially hidden!), but I was encouraged I was on the right track. My problem now is to get it to show the result in YYYY MM DD. I can get then to show separately but can't show them together. I think I might need to do...

I am new to formulas and am trying to work out the difference in months and days between 2 dates. I have tried datediff ("d", start date, end date) but it doesn't return the correct number of days per unit. Thanks in advance Sarah

I want a report to show contacts on a Saturday and Sunday over a 3 year period. I am stuck trying to show only the contacts for Saturday and Sunday. I am not very experienced with formulae so please forgive me if this is very basic. I have looked over some previous threads but have got a...