Getting Current Date AND Time
I would appreciate help with the following.
I am trying to get the current date and time and add or subtract minutes/hours/days/months to this time.
However, the "Date" command only returns the current date (with a default time of midnight) and the "Time" command only returns the current time. Is there any way to get both Current Date and Current Time at the same time so I can use the DateAdd function to manipulate them?
Or is there a better approach to do this sort of thing?
Re: Getting Current Date AND Time
Figured out how to do this using the "Now" statement:
Dim periodBeginDate As Date
periodBeginDate = Now
'Subtract 58 minutes from Date/Time
periodBeginDate = DateAdd("n", -58, periodBeginDate)