I would like to do a database housekeeping function by ReportMiner. May I know how can I make an expression to define a date (today date – 5 days) as the selection criteria? Thanks.
This can be achieved by creating a formula field in the report model or by introducing a field in the dataflow using the function AddDays.
https://docs.astera.com/projects/centerprise/en/6/getting-started/functions-glossary.html#adddays-date-date-integer-days
In the parameters required, you can pass the function Today() as Date and -5 to subtract 5 days from the current date.
https://docs.astera.com/projects/centerprise/en/6/getting-started/functions-glossary.html#today