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

[@jeffmwango]

Ths is very informative and veery well explained. Thanks for sharing.

[@seanmackenziedataengineering]

Glad it was helpful!

[@ZahidKhan-mb6oc]

Very useful information, thanks my friend.

[@seanmackenziedataengineering]

I'm glad that worked for you!

[@NoumanAzam01]

Very Informative, I watched whole video just to know if I can calculate age in "ddmmyy" format from Date of birth. Plz help me.

[@seanmackenziedataengineering]

You can see how to calculate Age here: learn.microsoft.com/en-us/office/vba/access/concepts/date-time/calculate-age You probably need to convert your ddmmyy to a date variable type before you pass it to the function. You can do this using CDate(). Also, you may need to make your year a 4 digit year to be clear since auto conversion of "031202" may screw up.

[@BambooCollege]

Nice, but how can i add year and month and days at the same time.?

[@seanmackenziedataengineering]

Great question. Just use 3 DateAdd statements in a row.

[@stanTrX]

thanks Sean. do you think we can calculate the date difference between a date value and the previous date value of a table using query in ms access?

[@seanmackenziedataengineering]

Yes you can! When you look at the same field but a prior record, you can simulate what is called a "Window" function using Lag: kzbin.info/www/bejne/b5q2pnxpmbdqa9E

[@stanTrX]

it works like magic. thanks a lot Sean

[@seanmackenziedataengineering]

@@stanTrX awesome!

[@BambooCollege]

Like 3year and 5monthe and 11 days. what should i do now.?

[@seanmackenziedataengineering]

You can add three statements in a row. First, year, then month, then days. Increment your variable each time. ie: dteNow = Now() dteCalc = DateAdd("yyyy", 3, dteNow) dteCalc = DateAdd("m", 4, dteCalc) dteCalc = DateAdd("d", 11, dteCalc)

[@gerfer6261]

☑️

[@seanmackenziedataengineering]

Glad that worked!

[@MrKenCollectibles]

I'm new to using MS Access. I need to find a way to update a field with a new date when another field is changed. Did I miss something in this video. Any assistance would be greatly appreciated

[@seanmackenziedataengineering]

You can use the After Update event in your form for the field you will change. This is Before Update but it is similar: kzbin.info/www/bejne/gHe8eWqjotSFldU If the other field is in another table, you can use a data macro: kzbin.info/www/bejne/jXq6o4CsoNhkjdE