Adjusting time from server time to local time

[Tim356]

I've been using

Code: Select all

FormatDateTime(Now,3)

to display the time of post in the blog I'm creating, but of course that's server time.

How can I adjust the display time?

[courtjester]

I guess you could always subtract (or add may depending on the case...) your time with the server time. Then display that.

[Webforumz Staff]

You mean, you want it to display relative to the time on the client side?

The only way I can think of doing that is with a Javascript, which is fed your time zone and works out the time on the client machine.

[Smokie]

I think Court Jester has a point, if you know the time difference between you and the server, just subtract the appropriate amount of hours...

If England hadnt lost last night and I hadnt got so drunk, i wouldnt be feeling so ill today and i might have written the code to do this but, in my current state, i cant!

[Tim356]

I've tried adding the appropriate amount of hours (17 to be exact), but I keep having problems. I can get it to do it, but then the date is still yesterday... and then I have the problem of converting it to 12 hour clock:

Code: Select all

if xtime > 12 then
xtime = (xtime)-12
end if

(something similar to that)
but when the server time is 10am, add 17 hours, becomes 27:00, minus 12 hours, 15:00... no no no... I gues I could add more if statements there (if xtime > 20 then...). I'll give that a go tomorrow. It's 12am here almost, so I'm going to bed, I was up til 2am last night doing this...

My brain is too messed up, need sleep.

[Smokie]

Code: Select all

NewDate = DateAdd("h", 17, Now)

[Tim356]

This will add 17 hours to the server time? Excellent, champion...

Thanks!

[Rob]

lol smokie.

your one-liners crack me up.

However Smokie, as a great teacher of coding practice, I'm sure you meant:-

Code: Select all

NewDate = DateAdd("h", 17, Now())

[courtjester]

THAT A BOY ROB!!!! LOL

[Smokie]

blame Microsoft...

[Tim356]

Thanks Rob!