Results 1 to 3 of 3

Thread: [RESOLVED] add 24 hours to a time

  1. #1

    Thread Starter
    PowerPoster isnoend07's Avatar
    Join Date
    Feb 2007
    Posts
    3,237

    Resolved [RESOLVED] add 24 hours to a time

    this works for adding a week to a date
    Dim newdate 'add a wreek
    Dim mydate
    mydate = gridMaster.textmatrix(mintgridMasterCurRow, 3)
    newdate = DateAdd("ww", 1, mydate) add a week
    gridMaster.textmatrix(mintgridMasterCurRow, 3) = newdate

    i need to add 24 hours to a time, how ?
    the time is in this format 9:00 AM
    Last edited by isnoend07; Jun 20th, 2016 at 10:12 PM.
    Waiting for a full featured smart phone with out marrying a provider
    Go Android
    Go raiders

  2. #2
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687

    Re: add 24 hours to a time

    same way, using addDate ... with a time part of "h" (for hour) and a value of 24.... or "d" for day and a value of 1.

    -tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *

  3. #3

    Thread Starter
    PowerPoster isnoend07's Avatar
    Join Date
    Feb 2007
    Posts
    3,237

    Re: add 24 hours to a time

    thanks
    Waiting for a full featured smart phone with out marrying a provider
    Go Android
    Go raiders

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width