title: SSRS subscription - change the date format (@ExecutionTime) on the subject line
body: <p><strong>Problem</strong>: 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.</p>
  
  <p>Most of the posts on the internet have suggested using data-driven report subscription to construct a custom email subject.  But as per SQL Server documentation, this feature is available in Enterprise and BI editions only.</p>
  
  <p>Other attempts to use =Parameters!ExecutionDateTime <strong>or</strong> =FORMAT(@ExecutionTime,"dd-MMM-yyyy") <strong>or</strong> =format(Globals!ExecutionTime , "MMM yyyy") have failed.</p>
  
  <p>Two days of futile attempts in solving this.  Will continue looking, and hope the SO community can help.</p>