Pacific > GMT 2

[loganswell]

Hi people,

I have a web site that is hosted in California and I am in Scotland (UK GMT+1 [BST or daylight saving time])

When people add entries to the guestbook (which is an Access database) it is showing as local (Pacific?) time.

The database is set up just as a date/time field. Is it possible to change the Now() so that it adds 8 hours every time an entry is made?

Many thanks!

Jim )

 

[SkipVought]

Hi,

Now()+(8/24)

Skip,
[sub]
[red][/red]
[/sub]

 

[Golom]

Or ... Living Dangerously

Function Now() As Date
    Now = DateAdd("h", 8, VBA.Now)
End Function