I am converting a report from BO to Cognos and one of the query items in BO is as follows
=RelativeDate(ToDate([Full Date];"MM/dd/yyyy");-6)
I am looking for the Cognos equivalent of this function.
Thanks for any answers in advance.
This should work:
_add_days([Full Date],-6)