Re: Table fields displaying 1 hour difference from searched date.

2010-08-06 Thread Robert Halstead
So it seems like the table itself may not be the issue, though i'm not entirely sure. What I setup was a display form with two date/time fields for input, a character field for the EXTERNAL(query), and the table field pointed to one of our most populated forms. What I found out was this: I

Table fields displaying 1 hour difference from searched date.

2010-08-05 Thread Robert Halstead
Hey all, We're seeing a discrepancy when displaying data in a table field. If the table field is searching a date range of tickets, the table field seems to display tickets that are an hour ahead. It seems the client takes the date/time in the date/time fields and applies +1 hour to them and