Using QlikView Variables in NPrinting (Sept 2018) output file names

[kdmarkee]

I need some help with how I should be setting up the code in my QlikView app for a date variable so that when I use that variable in the output file name of an NPrinting report, it comes out as a date.  I want to use the highlighted variable in my NP output file name as shown below...

My QV logic looks like this right now:

set vAccountingDate = Date([MonthEnd.Accounting Date], 'M/D/YYYY');
set vNPAccountingDate = $(vAccountingDate);

 $(vNPAccountingDate) works fine in QV app but when used in NP it comes out like this (I want the red text to be the date):  Fusion Month End Report_Date([MonthEnd.Accounting Date], 'M_D_YYYY')_KMark (999-224).pdf

Thanks for you help.

[sunny_talwar · Accepted solution]

Can you try this

SET vAccountingDate = '=Date([MonthEnd.Accounting Date], ''M/D/YYYY'')';

[sunny_talwar]

And then use vAccountingDate in nPrinting

[kdmarkee]

Thank you for your quick response.  I will try this and let you know how it works; the report runs awhile.

[pradosh_thakur]

Else you can just change set to Let.

[kdmarkee]

That worked, thanks again.