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 because my date fields are called FISCAL_MONTH and FISCAL_YEAR. How can I get the report to run for the current month/year?
I'm sure the smart people will have a better answer, but I would use the MakeDate function to create a QV style date field. If your format is ALWAYS "YYYY/MM" (not YYYY/M ~ 2015/1 for January), you could use:
MakeDate(left(FiscalMonthYear,4),right(FiscalMonthYear,2)) As QVFDate
for 2015/04, for example, you would get a date stamp of 2015-04-01 00:00:00
You can then use the standard QV date functions as I suggested earlier.