locked
weird problem with search by date RRS feed

  • Question

  • Hello all.
    I'm working with css3.0 and developing in c#.

    When i'm importing document into sharepoint it writes the creation date to the "Created" column of the document.
    When i'm search (FullTextSqlQuery) for this document by it's 'created' date - sharepoint can't find him.

    For example:

    my document details:
     file name: aaa
     created: 11/24/2008 3:33 PM
    my search query:
    select title  from Scope()  where created <= '2008-11-24 15:34:00'

    but when i'm adding at least 8 hours to the search query - the document found:
    select title  from Scope()  where created <= '2008-11-24 23:34:00'

    What could be the problem?

    • Moved by Mike Walsh FIN Tuesday, December 2, 2008 4:17 PM wrong forum (Moved from SharePoint - Development and Programming to SharePoint - Search)
    Tuesday, December 2, 2008 4:09 PM

All replies

  • Search questions always go to the Search forum.

    Moving this
    Tuesday, December 2, 2008 4:17 PM