Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    139

    Unanswered: simple query question

    In SQL server I would like to define a date range that is the current date - 10 days. In Access that would look something like:

    Date()-10

    Can anyone help me define this in SQL Server?
    Thanks,
    Bill

  2. #2
    Join Date
    Oct 2004
    Location
    Korea
    Posts
    9
    use query like this : getdate() - 10

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I'd use something like:
    Code:
    SELECT DateAdd(day, -10, GetDate())
    -PatP

Posting Permissions

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