troubleshooting Question

Add time to a date field in Ms access

Avatar of Sivasan
SivasanFlag for United States of America asked on
Microsoft Access
10 Comments1 Solution739 ViewsLast Modified:
Hi there,
I have an event in access form where I have a datetime field where I take the date part of the field and I need to add a hard coded time of 8:30 am. Please let me know the correct format/Syntex for this.

Dim uptime as date

uptime = Format (entertime,"mm/dd/yyyy")       + 08:30  (when I try adding 8:30 doesn't work

so if entertime is 5/27/2012 10:00 am  
I want uptime to be 5/27/2012  8:30 am  so basically take the date value from entertime and add 8:30 am to it and assign it to uptime.


Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 10 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros