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

[dunncrew]

This is a snippet from one of my dataflows in the WHERE clause.

to_char(RECORDDATE, 'yyyy.mm.dd') > to_char(sysdate()-45, 'yyyy.mm.dd')

[siba_pkd21]

Hi Dunncrew, Thank you for answering, May I please know what value should I give for yyyy.mm.dd before > and after > , 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