Recent content by alexlc

Hi, Yep, that's it, I can potentially have 56 start times, or just 1, same for end times. It's a joy isn't it? I wish there was a way I could put a picture in here so you can see the form as the end user sees it. I'm currently writing Start formulas to make the Time field a DateTime field...

Thanks all, The problem is that all 56 fields could have data in - the care plan holds all shifts for any given week (so the Start & End Time fields are "Time" data, not "DateTime" data), there might be 2 AM calls starting 08:00:00 & ending 08:30:00, then 2 lunch calls at 12:00:00 - 12:30:00...

Hi, That's what I'm waiting for IT to do for me - I'm not a Lotus programmer, but they have a list of jobs to complete before they can look at this & I have another manager asking for the data. Unfortunately the system is all designed for the front end user with little thought to data...

Hi, Using Cr9, accessing Lotus via ODBC Form/Table is Care Plan & holds details for recurring shifts for a service user, with start & finish times for each shift. Field names: {CarePlan.BedMondayFrom1}, {CarePlan.BedTuesdayTo1}, {CarePlan.LunchTuesdayFrom2} etc. There are potentially 56 shifts...

Thank you for asking the question - you just gave me the answer I was looking for :D

Argh, yes it is using yesterday's date! I've been looking at it for so long I just don't see it anymore! Thank you so much for lifting the veil, off to play now.

Hi, I'm usng Crystal 9 & accessing Lotus Notes via an ODBC connection. I'm calculating shift durations from a form which has the start time & end time of the shift, but doesn't calculate shift duration. Most shifts start & finish on the same date, but I have some shifts which start at 22.00 &...

Brilliant, first one worked perfectly :) Will have a play with the second one on a quiet day. Thanks both.

Thanks, but it doesn't like that & is returning no records at all. The number 3 may be used more than once in a single code, would that be affecting it? Forgot to mention I'm on Crystal 9 & querying an SQL database via OLE. Cheers, Alex

Hi, Our accounts system groups our sales into nominal codes, where the third number = sector. Is there a way I can write a Selection Formula to only return records from SL_Analysis.SACODE where the third number = 3 (for example). I've currently trimmed the field of the first 2 digit & am...

Thanks Ibass, sorry, should have made myself clearer, the {@Start DateTime} & {@ End DateTime} fields do reference the Start & End Time fields in the database (Lotus Notes). I am also putting the results in the details section, and it is throwing up the incorrect times there. It looksl ike its...

This is the formula for the DateDiff field And this is how I have used your formula above I've just checked back & {@Start DateTime} and {@End DateTime} are both CDateTime ({Shift.Date}, {Shift.Time}) - is that what might be throwing it out?

Thanks, It's a time field, which is a DateDiff formula formatted to hh:mm - although I have checked it as hh:mm:ss with the same results. So 07:00 is returning 420.00 as is 07:30 & the 425.00 is coming back from 07:45.

Sorry to butt in on the thread, but I've just used this formula & it's only partly worked, & I'm not sure why it's falling down. The formula above is returning incorrect values for some lines of data - for example it's returning 420.00 for both a 7 hour & 7 1/2 hour duration, and 425.00 for a 7...

Hi, I have a field of user actions, such as below: Staff Member NF selected by CW Client Confirmed with HELEN with Ref : 0909004045. Entered by CW Booking Edited by CW Staff Cancelled reason working 3 nights wants two days off by KP staff member was NF Booking Edited by KP Name Change Set By...