Modifying

Adding Days

The integer portion of a Date represents the number of days

Adding Months

DateAdd(

Adding Years

DateAdd(

No of Days

dtDate1 - dtDate2

No of Months

DateDif(

No of Hours

Removing Time Component

There are 3 common approaches used to remove the Time component from a Date and Time.
The DateValue function
If you pass in a Date data type, it returns a Variant-Date which just has the date You can also pass in string dates.

The Int function
If you pass in a Date data type, it returns the whole number which is just the date what is the data type returned

The Format function
returns a Variant-String