How do I count from TODAY for the next 30 days?
Date
Votes
1 comment
-
Hi Joe
Are you trying to count forward in your data source query, or in your formula?
For data source, you can use this doc
https://support.klipfolio.com/hc/en-us/articles/216181877-Date-parameters-in-data-source-queries
For formulas, we have a function called DATE_ADD
https://support.klipfolio.com/hc/en-us/articles/360011416893-Klipfolio-functions#DATE_ADD
In both cases, you'll use logic of taking TODAY() and adding 30.
So DATE_ADD(TODAY(), day, 30) or {date.add(30).today.format()}
If you'd like more specific help, please post back here, or feel free to open a support ticket support@klipfolio.com
Thanks!
Meggan
Please sign in to leave a comment.