Skip to Content
1
Oct 18, 2019 at 01:51 PM

Dates comparison in sap analytics cloud

394 Views

Friends

I am trying to compare 2 date dimensions to see the result value as "boolean" say True or False.

Context: say we have 2 date dimensions

1)Adate(MM-DD-YYYY)

2)Bdate(MM-DD-YYYY)

---------------------------------

Calculation/Comparision needed : If(Adate<=Bdate,"A" elsif Adate>Bdate then "B" else "NA")

Could you share your experiences...

Thanks-Bose