[tbig]

Hi guys,

I'm trying to save a record to the database where it takes the current time and adds 8 hours on to it. Reason being the server is located in a different time zone. Anyways I though I could do:

Code:

date & hour(time) + 8 & minute(time)

or..

Code:

date & hour(time + 8) & minute(time)

but both of these generated a "type mismatch" error.

Any help would be superb.

[rrhodes]

Use the "DateAdd" function to add 8 hours to your date.

Here is some doc: http://www.w3schools.com/vbscript/func_dateadd.asp

[tbig]

I knew it was something simple that I overlooked. Thanks =D