mccoy1000
Data Storage
Joined 3 years ago
User Profile
User Widgets
Contributions
Re: Dashboard time filter from dynamic TODAY until forever
Perfect! Works as advertised. FWIW "next" "x" days is not an off the shelf option in my org's sisense deployment, so the custom code was needed. Thank you! This allows the report to filter perfectly as needed for this situation.2KViews0likes0CommentsDashboard time filter from dynamic TODAY until forever
Hi. I have searched and cant seem to find this specific answer and I have tried multiple attempts of using currentdate(), today(), etc. I need a dashboard time filter that starts TODAY, end date doesn't matter as I can make it 20 years into the future (or just ignore). { "from": "2023-02-06", "to": "2030-12-31" } I need "from": to be dynamic for the actual returned system date. I know this should be remarkably easy, but as a non programmer I am struggling and cant get past invalid syntax query. This is going to be embarrasing, but here was my lastest attempt: { "from": FormatDate(Today(), "yyyy-MM-dd"), "to": "2030-12-31", "custom": true }Solved2.1KViews0likes2Comments