Sean MacKenzie | How to Use DateAdd, DateDiff, and DatePart in MS Access

Photo by Boris Pavlikovsky from Pexels

How to Use DateAdd, DateDiff, and DatePart in MS Access

27-July-2021
Knowing how to efficiently calculate dates in MS Access is an important skill. Knowing how to add or subtract time from a date, how to calculate the difference in dates, and how to extract the year, month, or day from a date is a skill that you will use over and over in your data engineering journey. Access provides three nice built-in functions for this: DateAdd, DateDiff, and DatePart. Join me and explore these date functions!

MS Access Project? Contact me today!

3 Reasons Why You Should Learn Data Techniques

Find 3 big reasons why you should learn data techniques if you are a professional or business person.

Read article

About our workshop

The Professional Problem, 3 Things They Need, and 1 They Don't Have

Why do people constantly run into problems with their data, even when they are highly trained in their area?

Read article

About our workshop

Why Finding Uniqueness is the Key: 6 Methods to Help

Find out why keys and uniqueness are so important for data transformation and data analysis.

Read article

About our workshop

When to Excel and When Not To: Why Specialists Don't Use Excel for Data Transformations

Start your journey in data transformation, and learn why specialists don't use Excel to transform raw data for analysis.

Read article

About our workshop