adding values to Now()

L

LB79

Registered User.

Local time

Today, 12:48

Joined

Oct 26, 2007

Messages

505

• Mar 8, 2010

• #1

Hello,

I thought this would be pretty simple, but I cant figure it out and cant seem to find something on the web for it.
I have a page that I want to display time zones. The first will be London using =Now()
The others will have +/- x depending on where they are.
Thing is, I cant seem to get the other txtboxs to sum. EG for Paris I've tried adding 1 to Now, I've tried adding 1 to the London txtbox…
Can anyone put me on the right path.

Thanks

 

pbaldy

Wino Moderator

Staff member

Local time

Today, 04:48

Joined

Aug 30, 2003

Messages

36,157

• Mar 8, 2010

• #2

Try the DateAdd() function.

 

N

namliam

The Mailman - AWF VIP

Local time

Today, 13:48

Joined

Aug 11, 2003

Messages

11,685

• Mar 8, 2010

• #3

adding 1 to a date is adding 1 day.

If you want to add one hour, you use either dateadd
or + #01:00:00#
or + 1/24