Creating Calculations between two dates in SAP Analytics Cloud

[Former Member]

Hello,

I am attempting to create calculations between two dates in SAC. SAC only allows one date dimension in the model so I am not able to compare the multiple dates and create calculations between the dates, without making direct modifications to the data set. It seems like we can't create calculations between dates in two seperate linked models either. If anyone knows how to create calculations between two dates in SAC, please share your knowledge.

Thanks.

[kohesco]

in the latest release they speak of datediff formula

https://www.sapanalytics.cloud/product_updates/release-2018-16/

[Former Member]

but the datediff function won't work, as you can only import 1 dimension as a date