converting a Date / Time system variable (Access DB)

[ghalewood]

My ISP hosts my ASP server in the US however any system time variables that I enter are in EST.

i.e I submit an entry in the UK at 11am and it's shows that the record has been input 6am.

I am using the following variable :
DateAdd("d", p_length, Now)

How do I add 5 hours ?

Thanks in advanced

 

[link9]

take whatever value you get from your statement, put it in a variable called 'theTime' (for this ex anyway), and:

theTime = dateAdd("H",5,theTime)


paul