bayouexpert
asked on
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?
FormatDateTime(@ExecutionT ime,2)
dont forget your =
ASKER
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
Screenshot.bmp
Subject.bmp
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.