date condition

[archanacg1]

Hi,
I am new to cognos and trying to pull all the ids greater than file_cre_ts. file_cre_ts includes date and time.  not sure how to put this in cognos

current date - trunc(file_cre_ts) > 90.


please suggest

[hespora]

Code Select Expand


[file_cre_ts] > _add_days(current_date,-90)