TimeStamp Issues

[mike760534211]

I have a database where it writes a few different timestamps into fields. This works correctly and is not an issue on the actual function. The issue is that I people updating records and the timestamp is for their local time and they are 11.5 hours ahead of CST.

Is there a way to force it to always write the timestamp in CST without regard to the timezone that the user is in?

To conclude I have to say I am very green in Access for this kind of function and any help would be greatly appreciated.

[June7]

Subtract 11.5 hours from their local time. Use DateDiff function.

If the db will be used within various time zones and you want all dates in CST, need to make the db 'smart' about where the db is and the time difference. One approach is a table of the timezones and time variances from CST. And using the correct variance based on where the db is which can be determined by code when the db is opened.

[mike760534211]

I already have a module that can read all the timezones from the system registry. The database would only be used in 2 timezones but i dont want it to calculate if the database is being updated in CST timezone.

Subtract 11.5 hours from their local time. Use DateDiff function.

If the db will be used within various time zones and you want all dates in CST, need to make the db 'smart' about where the db is and the time difference. One approach is a table of the timezones and time variances from CST. And using the correct variance based on where the db is which can be determined by code when the db is opened.

[June7]

An expression could use IIf:

DateDiff("h", IIf(timezone()="CST",0,-11.5), [datefield])