Date difference calculation in SAC?

[chandrasekhar6]

Hi Team,

How to calculate date difference in SAC Storyboard with HANA CDS Views(Live Connection).

Thanks,

Chandrasekhar

[former_member650982]

Maybe the information comes in as a text - and not a date - try and wrap todate around the two dimensions in the datediff formula

[Former Member]

Hi,

You can add a measure in the model bu adding and entry in an empty row and use formula.

Then you can use the Date Diff in the formula.

Please mark answered if you got it answered.

- Sathya

[chandrasekhar6]

Thanks for the reply Sathya.

I am trying to create a formula and "OK" button is disable mode

DATEDIFF([d/2CJ33FJHT41PSY4F1QJOGNDKNI4] ,[d/2CLIWSOOIJQDUH6SUW637JYS8T5] ,"Month" )

[former_member666653]

Hi,

Is your problem solved? I am having a similar issue.

Regrads

Reddy

[chandrasekhar6]

Hi Raghu,

Not solved my issue, our backend team creted in the CDS views.

Thanks,

Chandrasekhar