Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Mar 2002
    Posts
    164
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Date Question (2003)

    I have a report where I'd like to set the date automatically to the 1st of the following month from Now(). For example, today's date is July 16, 2006. I'd like to be able to display the following automatically, August 1, 2006. Is that doable?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Date Question (2003)

    Yep, try this in the Control Source of a text box:

    =DateSerial(Year(Date()), Month(Date())+1,1)

  3. #3
    2 Star Lounger
    Join Date
    Mar 2002
    Posts
    164
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date Question (2003)

    Wow, that was fast. Thank you very much. I may have asked this before, but do you have a recommendation on a VBA book? I've learned so much since I've discovered the forums (Especially with your help) but would love to continue to grow my knowledge.

Posting Permissions

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