Search results for query: *

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...

Hi, It's all in my first post. I think it's something to do with notes - I have had this error message before in another database & have a "fix" in the database for that. IT should be fixing it for me this morning. Thanks again. Cheers Alex

Hi, It's a time field - have just discovered that it is falling over because people are entering the same start & end time!!! Thanks for your help, but I'm giving this up as a bad job before someone come to harm. IT will be showing me how to correct the erro on the database tomorrow. Cheers Alex

Cheers Ibass, it usually works fine with the space etc, but anything that comes up with less typing is cool by me :-) Just run it again with those changes & the message says "Query Engine Error: 'HY000:[Lotus][ODBC Lotus Notes] Invalid time value' Usually it's poor data entry, grrrr Will try...

Hi, Our IT dept can't fix this on the database (Lotus Notes 6.5 accessed via ODBC) for me at the moment, & the job is quite urgent, so need a work around for poor data entry. I'm using this formula numberVar dur:= datediff("s",{@ShiftEnd},{@ShiftStart});//get the seconds between 2 dates...

I have BookingSummary and SubShift which is further detail on the booking. I have linked from Summary (one) to Sub-shift (many) via the Summary Unique ID number. I have just found the Select Distinct on the report option, and this has got rid of the duplicates - can't you tell I'm never in that...