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