Results 1 to 4 of 4

Thread: date & number

  1. #1
    Join Date
    Dec 2003
    Posts
    36

    Question Unanswered: date & number

    hi,

    I just want to know if its possible to count a number: example 15 with a date.
    What i want do is this:

    Date = 10/05/2003 (dd/mm/yyyy)
    number (representing days) = 7

    outcome = 10 + 7 days = 17/05/2003

    is this possible?

    (
    more info:
    *number (days) is entered in predefined table)
    *date --> date in textbox on the form at the moment
    *outcome --> by pressing a button i want to create a report with a field with the date and a field with the date + number
    )

    thx!
    daff
    ... man man man ...

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Yep. Try looking at the DateAdd function ... Ex:

    Dim MyDate as Date

    MyDate="#1/2/2004#"

    MyDate=DateAdd("d",7,MyDate)

    MyDate will now contain 8/2/2004 ...

  3. #3
    Join Date
    Dec 2003
    Posts
    36
    Originally posted by M Owen
    Yep. Try looking at the DateAdd function ... Ex:

    Dim MyDate as Date

    MyDate="#1/2/2004#"

    MyDate=DateAdd("d",7,MyDate)

    MyDate will now contain 8/2/2004 ...
    thx, will give it a try!
    ... man man man ...

  4. #4
    Join Date
    Dec 2003
    Posts
    36
    works fine,

    many thx!
    ... man man man ...

Posting Permissions

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