Forum Discussion
dmowry
Jan 28, 2022Brass Contributor
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.
- DannyBE1337Copper ContributorSimilar 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 - JamesDerrickCopper ContributorSame 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.