How to add number of days in a Date in SAC

[raj_trivedi]

Hi Experts,

As part of a planning process, I need to add the number of days/months based on user input to my second date dimension. I see we have the DATEDIFF function to derive the difference between 2 dates but please confirm if adding days to date is possible using any standard function?

Target date = Source Date + Number of Days (Which I will convert to Month if adding months is possible)

Thanks in advance.

[Alecsandra · Accepted solution]

Hi Raj

You can try the following DATA()=RESULTLOOKUP([d/Date]=NEXT(1,”Day”), does it help? Can you also share more details on the use case?

Thank you

Alecsandra

[raj_trivedi · Accepted solution]

Thank you Alecsandra.

I wanted to perform this calculation at the story level. But for now, we had to push this derivation within file itself and then upload.