Results 1 to 2 of 2

Thread: Date Query

  1. #1
    Join Date
    Jul 2004
    Posts
    191

    Unanswered: Date Query

    Hi all:

    I am trying to get data that wasn't used in the last six month. Created_on (date field)

    select Category_tree_value, Created_on from workitem
    where Created_on (field was used from the last six months)

    Created_on format (2005-10-01 00:00:00.000)


    Thanking everyone in advance.

    Lystra

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Try

    where Created_on < DateAdd(Month, -6, GetDate())
    Paul

Posting Permissions

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