Would be great to know, I am looking for something like today() or now() or now(month()) etc.
I have already checked the formula overview, however, there seems to be nothing there.
Thanks a lot!
Hi @Georg 0,
If you are looking for current date functionality in SAC App Design, then the following will work.
Refer the blog below to know more about the date and time functionalities in SAC App Design.
Hope this helps, let me know if you need more clarification.
Thanks a lot harikrishnans, very helpful blog!
So I assume, there is no way to have a now() or similar ins standard SAC story formulas? This is a little bit disappointing..
Hi @Georg 0 ,
Actually you can use "Date difference" functionality in SAC:
Small description and intro from SAP:
Thanks a lot. That helped to some extent! (to have this directly in the formula editor would be useful to be more flexible)
Hi @Georg 0 .
This functionality is available in the Modeler. If you have 2 date dimensions in your data model you can use the DateDiff formula to calculate deltas in different granularities:
SAC doesn't cover current date in the model but you could still do the calculation there if that helps.
I know, still thanks for writing. Current data should be available in the formula editor and the datediff formula in particular..