Current Date Function in SAC

[Former Member]

Hi All,

We want to have a filter in our story to take the current date automatically. Whenever I open the story the filter has to take that day's date as filter. Is there any function available in SAC to achieve this.

Regards,

Bhargavi.

[former_member411491]

Hi Bhargavi,

At the story level what you can do is to show the current data and Time and the last loaded data and time in the Text box by using dynamic Text functionality, which will indicate the user when the data is refresh last time. So that they can modify the filter accordingly.

If it meets your requirement then well. Otherwise, you can easily achieve it in application designer by writing script.

Steps:

1. Read the Dynamic text box and get the current date using dynamic text function.

2. Apply that filter in particular dimension column in a table.

https://answers.sap.com/questions/12877199/setdimensionfilter-not-working.html

Regards,

SG