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




© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited TopPrevNext