The integer portion of a Date represents the number of days
No of Days
dtDate1 - dtDate2
No of Months
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