Forum Discussion

mccoy1000's avatar
mccoy1000
Data Storage
02-07-2023
Solved

Dashboard 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
}

 

2 Replies

Replies have been turned off for this discussion
    • mccoy1000's avatar
      mccoy1000
      Data Storage

      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.