-
Solved: Add Hours to a time
Hi All,
I am capturing the received date & Time of the incoming mail to my inbox and the same is updated in access.
VBA captures it in the below provided format:
9/16/2008 2:07:52 PM
Now I have to add 48Hrs, 24Hrs, 4Hrs or 2Hrs as the case maybe to the received date & time.
How to go about doing the same.
Thanks
Sudhir
-
I got the solution
Its Dateadd function.
ex. dat = dateadd("H",48, "9/16/2008 2:07:52")
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules