I have amended the Sales Price table to use DateTime fields rather than date fields but have noticed that all the historical data in this table has changed since the British Summer Time change. An example is a Start Date/Time of 17/03/05 08:00 has suddenly become 17/03/05 08:00. The data itself hasn’t been changed so I can only presume that it’s something to do with the clock change. All of the new data that is being imported into this table comes in as an 08:00 starting time. Somehow I suspect that come october that will magically change to 07:00. The customer is running Navision through Terminal Services but I have checked all of the servers and they appear to be setup as GMT and the times are correct. I’ve also checked the SQL table and the datetime is correct (Still showing as 08:00) in all of the records. Does anyone know why the time would suddenly start displaying differently in the client? Thanks Stoo[?]
Because the TimeZone… 
I assume that you want to write that the time changed from 7:00 to 8:00 - yes, because the time was 7:00 but for the summer time it means 8:00… all is correct… You see the time in your local time… if you connect from another client (or change your timezone) you will see it in new local time…
We had this same issue and decided to use the Manufacturing style Date-time field. Look at Field 98 ‘Starting Date-Time’ in Table 99000830. It is a decimal data type with a special AutoFormatType and AutoFormatExpr. To see the details of how these decimal date-times are handled look in codeunit 1 at the ‘Fmt Decimal’ and ‘Eval Decimal’ functions. Also look at Codeunit 416 Datetime Mgt. Hope this helps.
I am in the GMT time zone so are all the servers and all of the users. The times showing in the datetime field should be 08:00 in all cases. Whether they were entered before or after the time change should not matter should it? The SQL tables show the time as being 08:00 so why would the client show it as 09:00? Does it look at the date stamp on the SQL record and recalculate the DateTime based on any time adjustments since the Date Stamp? Confused…
Cheers Zarryn it all becomes clear… Having gone back and looked at the help for datetime it also explains it fairly well. A typical case of RTFM!!