[AccessD] New thrd: dates

The best solution in a geographically diverse situation is to store all dates/imes as UTC  (or 
as "Unix Time")

It's simple to convert between UTC and local time when required with a couple of API calls.
Unix/Local is also fairly simple.

-- 
Stuart


On 22 Aug 2014 at 14:13, James Button wrote:

> 
> To my mind it is best to use the organisations 'home location Standard
> time' as in if the organisation is 'based' in NewYork all timestamps
> are using the standard time there.
> 
> It will still be appropriate for many sets of data to include a local
> timestamp.
> 
> Having both allows the results of searches to be shown in timesequence
> for both local (legal) purposes, and worldwide for corporate purposes.
> 
> JimB
> 
> And Bill, please keep asking the questions that are awkward to answer
> certainly gets the forum thinking and even some edukatun
>