SSRS subscription - change the date format (@ExecutionTime) on the subject line

Vote count:

0

Problem: The default subject line in an SSRS subscription email uses the @ExecutionTime pre-defined variable and at runtime replaces the same with a datetime in mm/dd/yyyy hh:mm:ss format. Since, we have deployed our product for an Indian client, we would like the date format in dd/mm/yyyy format.

Most of the post on the internet suggested using data-driven reports to construct a custom email subject. As per SQL Server documentation, this feature is only available in Enterprise and BI editions.

Other attempts to use =Parameters!ExecutionDateTime or =FORMAT(@ExecutionTime,"dd-MMM-yyyy") or =format(Globals!ExecutionTime , "MMM yyyy") have failed.

Two days of futile attempts in solving this. Will continue looking, and hope the SO community can help.

asked 56 secs ago

Tushar Sood

133

SSRS subscription - change the date format (@ExecutionTime) on the subject line