Available in Plus and Premium editions
Available in versions 1.73 and later.
CloudAnswers Report Sender supports using Date and DateTime merge fields in the following fields while setting up a report schedule.
File Name
Email Subject
The syntax for the merge fields are:
{!date(dateFormat)}
{!datetime(dateFormat)}
Where dateFormat accepts Simple Java Format as described in the Oracle docs. This value is computed at the time of sending the report and will resolve to the Date or DateTime value at that moment as per the timezone of the running user.
Tip: When you enter a merge field in the Name or Subject, a preview will be shown below the field using the current date/time.
Examples
Date merge field
Format: {!date(dateFormat)}
Merge Field | Output |
{!date(dd-MM-yyyy)} | 31-07-2023 |
{!date(MMM)} | Jul |
{!date(M-dd)} | 7-31 |
{!datetime(MMM dd)} | Jul 31 |
DateTime merge field
Format: {!datetime(dateFormat)}
Merge Field | Output |
{!datetime(dd-MM-yyyy hh:mm)} | 31-07-2023 11:00 |
{!datetime(MMM dd hh:mm a)} | Jul 31 11:00 AM |
Note: When using DateTime, remember that Report Sender runs in Apex using shared resources, so the time may not be exactly the scheduled time, but may be delayed by a few minutes depending on the system queue and the time it takes to send other reports scheduled at the same time.