topic NPrinting and Custom Date Filter in Qlik NPrinting

NPrinting and Custom Date Filter

cbaqir — Tue, 31 Mar 2015 17:51:08 GMT

I am using NPrinting and have a date field I use in the QVW called FISCAL_MONTH_YEAR which is formatted like 03/2015. I need to get my NPrinting report running for the current month but using =month(now()) & =year(now()) don't achieve what I need. How can I get the report to run for the current month/year?

TIA

Re: NPrinting and Custom Date Filter

Andrea_Bertazzo — Tue, 07 Jul 2015 06:40:28 GMT

Hi Cassandra,

You can use this formula:

=date(now(),'MM/YYYY')

This returns the today month and Year in the format you require.