saving a qvd with reload date into title

[#1]

Hello,

I want to load and save weekly a qvd file. I put on the beginning of script a variable vReloadStart=now() which I want to use into saved file name.

But till now I didn't succeded saving qvd with reload date into filename. Haw can I do this?

let

vReloadStart=now();


Framework_temp:

SELECT     *,

'$(vReloadStart)' as DataReload,

FROM         FRAMEWORK.dbo.NETWORK_PRINTER

LEFT OUTER JOIN

             FRAMEWORK.dbo.PRINTER_STATISTICS ON NETWORK_PRINTER.PRINTER_ID = PRINTER_STATISTICS.PRINTER_ID

       LEFT OUTER JOIN

                      FRAMEWORK.dbo.NETWORK_ADAPTER ON NETWORK_PRINTER.ADAPTER_ID = NETWORK_ADAPTER.ADAPTER_ID

             LEFT OUTER JOIN

                      FRAMEWORK.dbo.PRINTER_STATISTICS_HISTORY ON PRINTER_STATISTICS.STATISTICS_ID = PRINTER_STATISTICS_HISTORY.STATISTICS_ID
;
store Framework_temp into 'C:\QW_Reports\Diverse\Lexmark\QVD\Framework_$(vReloadStart).qvd (qvd)';

Thank you!

Olivia

[#2 · Accepted solution]

file names can not contain /  and :

let

vReloadStart=now();

let

vReloadStartText=Replace(Replace(vReloadStart,'/','-'),':','_');

Framework_temp:

SELECT     *,

'$(vReloadStart)' as DataReload,

FROM         FRAMEWORK.dbo.NETWORK_PRINTER

LEFT OUTER JOIN

             FRAMEWORK.dbo.PRINTER_STATISTICS ON NETWORK_PRINTER.PRINTER_ID = PRINTER_STATISTICS.PRINTER_ID

       LEFT OUTER JOIN

                      FRAMEWORK.dbo.NETWORK_ADAPTER ON NETWORK_PRINTER.ADAPTER_ID = NETWORK_ADAPTER.ADAPTER_ID

             LEFT OUTER JOIN

                      FRAMEWORK.dbo.PRINTER_STATISTICS_HISTORY ON PRINTER_STATISTICS.STATISTICS_ID = PRINTER_STATISTICS_HISTORY.STATISTICS_ID
;
store Framework_temp into 'C:\QW_Reports\Diverse\Lexmark\QVD\Framework_$(vReloadStartText).qvd (qvd)';

[#3]

Thank you. This solved my problem. Have a nice day!