Consulting

Results 1 to 2 of 2

Thread: Solved: Add Hours to a time

  1. #1
    VBAX Mentor
    Joined
    Oct 2007
    Posts
    357
    Location

    Exclamation 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

  2. #2
    VBAX Mentor
    Joined
    Oct 2007
    Posts
    357
    Location
    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
  •