How to add dynamatic date in reprot's name
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-05-2025 06:16 PM
I'd like to create a report and send it on a schedule. How can I add a dynamic date in the email's subject and the Excel file name?
For example, if today is 3/6/2025, I want the report to include data from 3/1/2025 to 3/6/2025. The email subject should be 'Incident_3/1/2025 to 3/6/2025', and the Excel file name should also be 'Incident_3/1/2025 to 3/6/2025'.
Next time, the email subject will be 'Incident_3/7/2025 to 3/15/2025', and the Excel file name will follow the same format, and so on... Thanks a lot
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-31-2025 10:43 AM
I think you could make a Notification Email Script, and then call it from the scheduled report. For example, if your script is named "Dynamic_Date_Subject", you would call it using ${mail_script:Dynamic_Date_Subject}" in the message of the scheduled report.