SAP Knowledge Base Article - Public

2464206 - Dynamic dates in formulas in SAP Analytics Cloud


There is a requirement to use formulas and filters based on dynamic dates (e.g: CurrentDate()) in SAP Analytics Cloud.


  • SAP Analytics Cloud 2018

Reproducing the Issue

  1. Logon to SAP Analytics Cloud
  2. Create a story
  3. Add a widget to the story (e.g: Chart or table)
  4. Try to create a Calculated dimension using formulas based on current time


The functions current year or current date are not currently available in SAP Analytics Cloud.


This Knowledge Base Article, SAP‘s strategy, and possible future developments are subject to change and may be changed by SAP at any time for any reason without notice.
This document is provided without a warranty of any kind, either express or implied, including but not limited to, the implied warranties of merchantability, fitness for a
particular purpose, or non-infringement.

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.


BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, SAC, AnalyticsCloud, dynamic date, filters, current date, current time, current year, current month, document date, SAC , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Product Enhancement


SAP Analytics Cloud 1.0