Calculate rolling 24 months date based on sysdate in BODS.

[former_member679919]

Hi All. I am working on a requirement to calculate the rolling 24 months date based on sysdate in BODS . In oracle it was implemeted as follows:

TRUNC(ADD_MONTHS(SYSDATE - 730,1),'MM'). I am unable to implement the same in BODS since trunc does not work on dates. Please help me on this issue.

[Julian_Riegel · Accepted solution]

Hi there,

try this:

(ADD_MONTHS(SYSDATE(), -24)) - (day_in_month(ADD_MONTHS(SYSDATE(), -24))-1)

regards,

Julian

[former_member679919 · Accepted solution]

Thanks a lot Jiulian. It works ....