Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Can you try this
SET vAccountingDate = '=Date([MonthEnd.Accounting Date], ''M/D/YYYY'')';
Can you try this
SET vAccountingDate = '=Date([MonthEnd.Accounting Date], ''M/D/YYYY'')';
And then use vAccountingDate in nPrinting
Thank you for your quick response. I will try this and let you know how it works; the report runs awhile.
That worked, thanks again.