Skip to Content
Product Information
Author's profile photo Aruna A R

Relative Date Function in Analytical KPIs / Apps

Relative Date Function is a feature function to return a date that is relative to a base date. Depending on the date function chosen the corresponding start and end date gets automatically calculated. As part of standard delivery there are predefined date functions like for example

  • PREVIOUSYEARTODATE: If current date is 30th August 2019, then this date function shall return date range: 01.01.2018 to 30.08.2019
  • MONTHTODATE : If current date is 30th August 2019, then this date function shall return date range: 01.08.2019 to 30.08.2019

so on and so forth. Given below is a screenshot of Value help for Relative Date Function from the Analytical KPI – Off-Contract Spend

Why is it necessary?

Dynamic filtering of data based on dates is a typical requirement in analytical apps / use cases, primarily the Smart Business Framework based KPIs. This enables you to use the pre-defined date ranges out of the box.

Can I create custom date range?

With the “Date Function” app, customer can define a date range that matches their own requirement. Refer to the help documentation here to understand how to create custom date ranges.

Can I define a custom date range without any pre defined base date?

No, currently it is not a supported feature

Can I display description instead of ID in the “Relative Date Function” Parameter?

No, currently it is not supported

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Sai Giridhar Kasturi
      Sai Giridhar Kasturi

      thanks for sharing

      Author's profile photo Abhishek Sharma
      Abhishek Sharma

      Hi Aruna A R

      May you share how you added Value Help to Date Function ?