Changing the time before updating the database
I am creating a record in an MDB database and one of the fields is a time value. My server is in the USA and our access if from India. I need to advance the time by 11 hours and 30 mins before updating the field. I am using the time() function to get the system time. How do i add 11 hours and 30 mins to it?