Recent content by Georgedooley

thanks LBass for both the very quick response and the correct soulution provided.

hi I have written a report that allows the user through a parameter select multiple dates. This works fine but I want to display on the report the dates that have been selected. I can do this for a single date and a date range but I cannot do it for multiple values. Please can anyone provide...

LBass, RsGeek. Any help on this please? Thanks

Thanks Lbass and RsGeek I'm not sure I understand your explanation. Do I create a new formula for saturday or add to my working days formula? Looking forward to your reply.

Thanks RsGeek I have already used this formula to calcualte working hours between 6am to 7pm monday to friday but the problem i have is I also need to calculate times between 6am and 10am on saturdays. Any suggestions?

Can anyone help me with this?

hi I'm trying to calculate working hours from the open time of a ticket to the close time. Working hours are Mon - Fri 6am - 7pm Saturday - 6am - 10am. I can do the mon - fri calculation but because the hours are different on saturday its giving me some problems. Formula used is. //Working...

hi Ian Sorry for the confusion. If i create the report just in crystal it is very slow as all the data is returned and filtered locally. I want to write a simple SQL command to allow the filtering be done on the server and only return to crystal the filtered information. I want 3 fields...

hi Ian There is a separate date field called scandate, This field type is Date. DISPLAY STRING(TIME,"HH:MM:SS") is used to diplay this interger in time format with progress DEFINE VARIABLE hour AS INTEGER. DEFINE VARIABLE minute AS INTEGER. DEFINE VARIABLE sec AS INTEGER. DEFINE VARIABLE...

Hi I am trying to create a SQL statement for a crystal report to pull all scantime records from a progress database for the last 2 hours. The scantime is a interger type field. This is a very large database, therefore I want to write an SQL query to pull back to crystal only the data I need.If...

hi Ian. I wrote the following formula. I think it will work. if currenttime in time (19,00,00) to time (23,59,59) then {@scan_date_time} >= datetime (today, time(19,00,00)) else if currenttime in time (00,00,01) to time (03,00,00) then {@scan_date_time} >= datetime (today -1, time (19,00,00))

Thanks for the help Ian. Any other ideas? I could maybe look at all scans for the past x hours as these scans only take place between 19:00 and 03:00. If i always look at the scans for the previous 8 hours i would pick everything up. Any suggestions how i can look at the last 8 hours, again...

hi Ian what do i use as shiftstartdatetime? i dont want to hard code the date, i cant use "today". I dont want to have to keep changing the startdate/enddate daily. Maybe i'm missing your point, if so please let me know. Thanks

datetime ({scaninfo1.scn-date}, timeserial (0,0,{scaninfo1.scn-time}))

Hi Ian We have a process where barcodes are scanned. I want to setup a dashboard that will give a simple sum of all scan records since the shift start time. This report will be auto refreshed every 5 mins during the shift. This will keep the operators aware of their progress. If the shift...