none
Need to add Today's Date to File syntax in Go To URL RRS feed

  • Question

  • I have a link in my report to pull a report from a shared drive as follows:

    file://SharedDrive/Filename.xlsx and need to add and automate today's date to filename similiar to: file://SharedDrive/Filename_20200103.xlsx

    I also tried using the javascript function as follows:

    ="javascript:void(window.open('file://SharedDrive/Filename.xlsx','_blank'))" which works fine, but need to add today's date automatically at end of Filename.  Such as using Now() or Today().  I haven't been able to find the syntax on how this works.  

    Thanks,

    LS


    • Edited by LS_SSRS Friday, January 3, 2020 7:18 PM
    Friday, January 3, 2020 7:17 PM