Forum Discussion

dmowry's avatar
dmowry
Brass Contributor
Jan 28, 2022

Today query in SharePoint Search not working anymore

Has anyone else had an issue with a query like RefinableDateXX={Today} not work for them anymore as of a few days ago? 

 

I've had a query i've been using for a few years and all of a sudden the items from a SharePoint list with a date field linked to a RefinableDate managed property no longer returns results for {Today}. I've had to use {Today-1} or {Today+1} but even that has been hit or miss. Especially when using an AND or OR for multiple dates or date ranges. 

 

Just wondering if i missed an update MS made or if something is broken. 

  • DannyBE1337's avatar
    DannyBE1337
    Copper Contributor
    Similar issues here with Search.
    the query created:01-01-1900..01-01-3000 works just fine and returns all documents it is supposed to
    the query RefinableDate00:01-01-1900..01-01-3000 returns 0 results
    the query RefinableDateSingle01:01-01-1900..01-01-3000 returns 0 results

    Then i tried mapping RefinableDateSingle02 to CreatedTime just like the managed property "Created" and above query, that worked just fine didnt work if i replaced "created" with "refinabledatesingle02"

    I have reindexed all document libraries and site collection, and more than 7 days have passed since the mapping
  • JamesDerrick's avatar
    JamesDerrick
    Copper Contributor
    Same issues for me. Reasonably new to sharepoint but I cannot get refinableDates to work as they should. Tried to map CreatedTime to RefinableDate00 but it just doesn't pick up a value. Have tried many combinations and the only thing that worked was mapping OWS_Modified, which I don't want but does at least work.

Resources