Use the TimeValue Function to Get Just the Time Portion of a DateTime Field in Microsoft Access

In this Microsoft Access tutorial, I'll show you how to use the TimeValue function to isolate the time part (only) of a DateTime value in Microsoft Access. This is handy if you have a lot of dates that include times but you only care about the time. We will then use the TimeValue function along with a Validation Rule to make sure that appointments are entered between 9 am and 5 pm for any given day.
LEARN MORE:
599cd.com/Time...
PRE-REQUISITES:
DateValue: 599cd.com/Date...
Validation Rules: 599cd.com/Vali...
RECOMMENDED COURSES:
Access Expert 27: 599cd.com/ACX27
Access Expert 28: 599cd.com/ACX28
DateTime Seminar: 599cd.com/Date...
LINKS:
Reserved Words: 599cd.com/Rese...
BECOME A MEMBER:
UA-cam: / @599cd
or My Site: 599cd.com/THMe...
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/Tech...
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.o...
products.offic...
microsoft.com/...
KEYWORDS
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #fasttips, just the time, convert date/time to time only, get time from a datetime, datetime field time only
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[@AlpArselan-l6n]

Sir, I'm getting the problem that the start and end hours are different days, but can you include the date and time in the Form? I saw in the video adding date and time only via Table, Please give me direction sir, thanks

[@viveksunny50]

Need some help from you sir, please:
Is there a way to split the “ current db.execute “insert into table(field1,
Field2,
field3,…
I have almost 121 fields and I want to split this statement into multiple lines, is there a way?
It generates an error when I press enter between fields. I’m forced to write all fields in one line.
🙏🙏

[@599CD]

No. I'm not helping you because you posted the exact same thing on 3 of my videos. That's not the way you get help.

[@ssdusd]

loved it👍

[@599CD]

Thanks

[@eladborovsky4716]

My users are having difficulty with entering date and time together - is there an option to split between date and time in the form?

[@599CD]

Sure... just make two fields, like I mention in the video. A lot of people do that, and there's nothing wrong with it.

[@599CD]

I also have popup templates to let users pick dates and times as well... 599cd.com/TimeP