0

Count the next 30 days

Jon Buhmeyer

February 12, 2020 20:31

None

Follow

How do I count from TODAY for the next 30 days?

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Meggan King February 20, 2020 14:03

  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