Results 1 to 3 of 3

Thread: date + 1

  1. #1
    Star Lounger
    Join Date
    Mar 2002
    Location
    Haaltert, Belgium
    Posts
    84
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hallo,

    I'm trying to add 1 to a date, like this.
    Code:
    Maand = Month(Date)
    DagBegin = Day(rst!maxeind) + 1
    DagEind = DagBegin + 6
    Jaar = Year(Date)
    PermBegin = DagBegin & "/" & Maand & "/" & Jaar
    F.e. rst!maxeind = 12/12/2009 then the outcome will be 13/12/2009

    This works, except is rst!maxeind is the end of the month.
    F.e. rst!maxeind = 31/12/2009 then the outcome will be 32/12/2009
    I need these dates for an insert query.
    Can some one help me on this please?

    Kind regard,
    Nancy

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Simply use rst!maxeind + 1
    Or equivalently DateAdd("d", 1, rst!maxeind)

  3. #3
    Star Lounger
    Join Date
    Mar 2002
    Location
    Haaltert, Belgium
    Posts
    84
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Many thanks, in mean while I did found it myself.
    I was to quick to ask for help.

    grts Nancy

Posting Permissions

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