Trying to add date to the Report Name in the subscription

  • I am trying to add the date to my SSRS reports filename. I have seen online you can do this by adding @timestamp to the filename.

    Then it shows something like below:

    Reporname_2019_06_05_102659. I need to do something like this :Reporname_2019_06_05. how can we do it in report subscription?

  • I don't think you can modify the @timestamp variable in the subscription like that, but even if you could, why would you want to? What if two reports executed within the same calendar day? how would you know which was the latest?

    -------------------------------------------------------------------------------------------------------------------------------------
    Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

  • I'm pretty sure Jonathan is correct and you can't modify @timestamp. I've seen others have a job or other process to rename the file and just strip off the time.

    Sue

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply