Dashboard time filter from dynamic TODAY until forever

[mccoy1000]

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
}

[Angelina_QBeeQ · Accepted solution]

Hi @mccoy1000 ,
You can use "next" in the filter. 

Or write the same custom one for the days:

{
  "next": {
    "count": 100,
    "offset": 0
  }
}

Always here to help,
Angelina from QBeeQ
[email protected]
QBeeQ - Gold Implementation and Development Partner

[mccoy1000]

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.