Hi @michael.kz -
Can you clarify exactly how you are storing the dates? The MongoDB date type is not time zone-aware, so the correct way of storing dates is to always normalise them to UTC for storage, and then you can convert them to your desired time zone for display or analysis. You may be doing this already but it’s unclear from your post so I wanted to establish this before looking at other possible issues.
Tom