Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    10

    Arrow Unanswered: Incrementing Month

    Can anyone tell me the command to increment the month in a date?
    eg DateVar = 12/31/04 > then add 1 Month.

  2. #2
    Join Date
    May 2004
    Posts
    10
    I have read that it should be soemthing like DateAdd("m", 1, "DateVar"), but this won't compile for some reason??

  3. #3
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    it should be something like DateAdd("m", 1, "DateVar"),

    DateAdd("m", 1, DateVar)

    or

    DateAdd("m", 1, #1/1/2004#)
    if you are using date literals.


    izy
    currently using SS 2008R2

Posting Permissions

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