• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1787
  • Last Modified:

Reporting Services Subject Line @ExecutionTime

The default "@ExecutionTime" in the subject line of a Reporting Services email subscribtion results in both the date and time.  I do not want the time to appear in the subject.  Is there a way to apply formatting to @ExecutionTime so that only the date appears?
0
bayouexpert
Asked:
bayouexpert
  • 2
1 Solution
 
SQL_SERVER_DBACommented:
FormatDateTime(@ExecutionTime,2)
0
 
SQL_SERVER_DBACommented:
dont forget your =
0
 
bayouexpertAuthor Commented:
I attempted to use the code that you provided, but I received incorrect results.  The attached picture files show 1) the subject line in the subscription 2) the subject line as it is displayed when the email is sent.  I tried adding the "=" in front of the FormatDate, but that had no impact on the displayed results.  Thanks.
Screenshot.bmp
Subject.bmp
0
 
Bob LearnedCommented:
I don't remember ever seeing anyone formatting the @ExecutionTime argument, and I wouldn't think that it is possible.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now