Use the DateValue Function to Get Just the Date Portion of a DateTime Field in Microsoft Access

In this Microsoft Access tutorial, I'll show you how to use the DateValue function to isolate the date 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 date.

LEARN MORE:

PRE-REQUISITES:

RECOMMENDED COURSES:

LINKS:

BECOME A MEMBER:

ADDITIONAL RESOURCES:

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 date, convert date/time to date only, get date from a datetime, datetime field date only

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[ndskim]

This tutorial is so helpful.

Is there a way to set a criteria to the current month in a query so I don’t have to change criteria every month?

[alex_gameplay]

I always enjoy your video and paid the annual full access on your site as well. I am looking find out how to create a continious calendar. I want to have a group of people on the left and look at their schedule all at once on a calendar.

People names on the left axis and the days of the month on the top row axis. I want to view everyone on one page and see empty space to task their availability.

I have been using this on excel for years I want to have it on Access Please help.

[ssdusd]

What is the deference between DateSerial and DateValue?