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.

[former_member104313]

Hi, This changed in a recent release. You can now have multiple dates in a model.

I have been using this with SuccessFactors data. The old solution was to split the date into Month/Day/Year and then use the year columns to calculate the date difference.

New issue since you can have multiple dates is how to type a specific date into a formula, no format seems to work. If you figure this out I would be super happy to hear.