To get records for last 120days(4 Moths) in BODS

[siba_pkd21]

Hi All

Need to see records for last 4 Months(120 Days) , this condition I need to apply in query transformation where clause in Designer based on a Date field-ERDAT which contains values in format: yyyy.mm.dd 

I tried to use below condition but bods not permitting this condition:

ERDAT >=  dateadd( day, -120, CURRENT_DATE());

Please anyone assist me on this .

Regards,

Siba

[Julian_Riegel]

Hi,

Try this:

ERDAT >= sysdate() +num_to_interval(-120,'D')

[siba_pkd21]

Hi Julian, Thank you very much for providing me the logic, will check and confirm...Regards, Siba