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.