NPrinting and Custom Date Filter

[cbaqir]

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

[Andrea_Bertazzo · Accepted solution]

Hi Cassandra,

You can use this formula:

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

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