Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Location
    Raleigh, NC
    Posts
    146

    Unanswered: Calculating a date

    I want to be able to enter a date (ex. 9/19/04) and then a certain number of weeks between 1-4 and have the database output the ending date. For example, if I enter 9/19/04 and then 3 for a number of weeks, the end result would be 10/10/04. What is the easiest way to do this?

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    dateadd("ww",3,#2004-09-19#)
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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