I have my server in US but my site for Thailand. So when I got the data in my server is US time how can I display it in Thai time.

Please help!!

Either add or subtract the time difference, e.g.

This will add 6 hours:

<%
varUStime = Now()
varThaiTime = DateAdd("h", 6, varUStime)
%>

This will subtract 6 hours:

<%
varUStime = Now()
varThaiTime = DateAdd("h", -6, varUStime)
%>


Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

Where should I add the code to?

new to this

In the VBScript part of the page - it's very difficult for me to be specific, what are you trying to acheive?

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

I would like to set the way the the time data collectting on the access database.
Example: I set the default value of my time table to Now()+1 that will add one day to the date and put it in database

But hour tomake it add 13 hour ahead for Thailand Time

I don'tknow how to write it

Try making the default value of the database field:

DateAdd("h", 13, Now())

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

Thank you so much, Owen

It is working the way I wanted now



Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo