Please help. Does anyone out there know how to subtract 1 hour (60 minutes) from the current system date and time and give the result in the same format using VBA?
What I have in mind is using the Now function in VBA to retrieve the current system date and time, subtract 60 minutes from it, and then display the result in the same format.
That is, if Now = 09/01/2003 09:30, then less 60 minutes, the result should be 09/01/2003 08:30
Please help.
What I have in mind is using the Now function in VBA to retrieve the current system date and time, subtract 60 minutes from it, and then display the result in the same format.
That is, if Now = 09/01/2003 09:30, then less 60 minutes, the result should be 09/01/2003 08:30
Please help.