The "Use a Dynamic File Name" option does still/currently exist, contrary to a comment on the last answer. The example below creates a filename with a date, from which 1 day has been subtracted.

The run date of this example was August 18, 2025. This code in the Dynamic File Name expression

'TMP_My_File-'||TO_CHAR(Add_To_Date(sysdate,'DD',-1), 'YYYYMMDD_HH24MiSS') ||'.csv'

resulted in a file being created with the name of "TMP_My_File-20250817_195243.csv"