Search results for query: *

It turned out I had a problem in my ingres driver installation. I had chosen GMT as my time zone in the installation, however my colleagues have this setting as United Kingdom. After changing this, a date/time field is now showing a correct time on a refreshed report.

MaxiMark Just for the sake of it I checked the time zones on mine, a colleagues and the server machine and all are showing GMT Daylight Time. Could it be a problem where the Ingres driver I am using does a conversion on the times I retrieve off the database, although there are no options to...

I only replaced the first line of code with your code. I can confirm this is a database field. If I click on Insert | Field. In the field explorer window I expand database fields and I expand the depot_bay_move table. The field dbm_date_time is shown with a green tick next to it meaning it's...

dgillz I have tried the code you posted. I was returning 34 records on this report, after I changed to your code I returned 91126 records returned by the database. Also the DateTime field is still one hour behind a colleagues version.

I will try this code and post the results tomorrow. The answer to your second question is Yes, when the report is run on a colleagues machine the time matches what we know is right, but when run on my machine we get a different result, exactly one hour behind. Many Thanks.

Yes thats correct. The first line {depot_bay_move.dbm_end_date_time}<cdate(0) is a check to make sure no null values are shown.

The field i'm reporting on is coming straight off the database, it has no other formatting. I can't even make this field show correct even if I view it on it's own, the record selection formula is: {depot_bay_move.dbm_end_date_time}<cdate(0) and {depot_bay_move.dbm_bay_code} startswith...

I am using Ingres driver version 2.80.00.60 to access a database to refresh a report written by a colleague. The problem is when I look at a DateTime field using crystal it shows the time 1 hour behind. A colleague with exactly the same setup runs the same report and gets the correct time. I...