22.5 Relative Date and Relative Time Filters
| Filter type | Settings | Example |
|---|---|---|
| Relative date | Show items when the value is in the last / is in this / is in the next, a number, and a unit: days, weeks, weeks (calendar), months, months (calendar), years, years (calendar); Include today | Order Date is in the last 30 days; is in this month |
| Relative time | is in the last / this / next N minutes / hours | Order DateTime in the last 2 hours (near-real-time monitor) |
Calendar vs rolling
"Last 1 months (calendar)" = the whole previous calendar month (e.g. all of September). "Last 1 months" = a rolling window ending today. Also, relative filters use the current date/time at query time. Check the current documentation on time zones, karan an IST report viewed near midnight may behave differently in the Service.
Ravindra Bagale's Tip
Friends, pay attention: relative date filters use today's date, and students forget that the Service may evaluate "today" in UTC, which differs from IST around midnight. Also check whether "Last 7 days" should include today. Test relative filters after publishing, not only in Desktop. Try it once more, then move on.
Ravindra Bagale's Tip – मराठी
मित्रांनो, लक्ष द्या: relative date filters आजची date वापरतात, आणि students विसरतात की Service "today" UTC मध्ये evaluate करू शकतो, जो मध्यरात्रीच्या आसपास IST पेक्षा वेगळा असतो. "Last 7 days" मध्ये आजचा दिवस धरायचा का ते पण तपासा. Relative filters फक्त Desktop मध्ये नाही, publish केल्यानंतरही test करा. पुन्हा एकदा करून बघा, मग पुढे जा.
Ravindra Bagale's Tip – हिंदी
दोस्तों, ध्यान दो: relative date filters आज की date इस्तेमाल करते हैं, और students भूल जाते हैं कि Service "today" को UTC में evaluate कर सकता है, जो आधी रात के आसपास IST से अलग होता है. यह भी check करो कि "Last 7 days" में आज शामिल होना चाहिए या नहीं. Relative filters को सिर्फ़ Desktop में नहीं, publish करने के बाद भी test करो. एक बार फिर करके देखो, फिर आगे बढ़ो.