setting time

[Alex]

Hi - I have a field in a table which simply inserts the current date and
time using the now() function. However this is now based on the server is
the Us so I need to add 6 hours to the now() statements - is this possible
[please?

tks
A

 

[Allen Browne]

6 hours is a quarter of a day, so try:
=Now() + 0.25

 

[Guest]

=DateAdd("h",6,Now())

yay i answered a question!

 

[Alex]

Hi both

Thanks - both worked - I added Allen's and it converted itself to:
Now()+#06:00:00#

Alex