Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

On Office 365,

We have a couple of DateTime managed properties, an ExpiryDate and a Article Start Date, in order to show/hide content from the news section. We are seeing an issue where the query : ArticleStartDate>={Today} uses the UTC date for {Today}. I had thought SharePoint will respect the user’s and sites regional settings for the query of a datetime managed property. But this doesn’t appear to be the case?

For example in Australia right now it is 9/04/2014. But the Today variable is 8/4/2014.

This effectively breaks all date range queries!

Any one come across this previously or have a workaround?

share|improve this question
Did you ever find a solution to this issue? –  Nick Larter Aug 27 '14 at 7:43
I'm stuck with the same issue.. Did you ever find solution for this issue ? –  ravi kumar mvs Feb 9 at 15:04

1 Answer 1

Are the users setting their local time zone? I can't remember off the top of my head, but the time will default to the Web Application time unless they override this and set their local on their own profile. Let me know and I can try a test.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.