Reporting Services Subject Line @ExecutionTime

Posted on 2009-02-23
Last Modified: 2013-11-26
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?
Question by:bayouexpert
    LVL 16

    Expert Comment

    LVL 16

    Expert Comment

    dont forget your =

    Author Comment

    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.
    LVL 96

    Accepted Solution

    I don't remember ever seeing anyone formatting the @ExecutionTime argument, and I wouldn't think that it is possible.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK ( for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
    From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now