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