ETL and Data Integration tools - Modern ETL software for everyone

I am utilizing the Export Data object within a package. The target file name from the export is named as follows.

"G:\itg\Business Intelligence\ETL\Load Files\Testing_1\Monthly Timesheet_{GetSystemDate('YYYYMMDD')}.xlsx"

This works well but I have a need to name an export file with the previous day's date. How can I get sysdate -1 for the previous day?

Please help.

try this one

"G:\itg\Business Intelligence\ETL\Load Files\Testing_1\Monthly Timesheet_{FormatDateTime('yyyymmdd',now-1)}.xlsx"

Mike

It worked perfectly. Thanks for your assistance!