troubleshooting Question

Combine Short Date field and Short Time Field into One Date/Time Field

Avatar of mlcktmguy
mlcktmguyFlag for United States of America asked on
Microsoft Access
4 Comments1 Solution442 ViewsLast Modified:
The user in my application need to record the Date and Time of an event on a form.  They asked that the two fields be split into an EventDate(Short Date) and EventTime(shortTime) fields.  They feel it is easier to enter them individually.  The date is entered as short date (12/23/14) and the time is entered as short time (13:24).  When I store the records I want to store a combined date and time.  How do I ocmbine these two individual fields into one consolidated Date/Time

The form:

Event Date
Event Time
Join our community to see this answer!
Unlock 1 Answer and 4 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 4 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