NPrinting - Fiscal Year filter with if condition

[Anonymous]

Hello,

I have a question related to NPrinting filters.

Within my application I have a filter for the current Fiscal Year.

The fiscal year is starting at the 01.10. and it ends at the 30.09.

The calculated Year value for the current fiscal year is 2016.

My question is, is there a possibility to calculate the fiscal year within NPrinting depending from the e.g. month number?

For example if (vCurMonth >= 10, FiscalYear(today(0)), FiscalYear(AddYears(today(0), - 1));

The variable vCurMonth is also calculated in the script.

Many thanks in advance and best regards,

Claus

[mkelemen]

Hi Hana,

create a filter for Posting_Date and try this formula inside (+ check the Evaluate flag)

=Posting_Date >= Date($(vFrmDate_Fmt)) and Posting_Date <= Date($(vToDate_Fmt))

Depending on what is inside the variables you may need to put them into ' ' and / or use the Date#() function.

BR,

  Matus

[#3]

Dear ,

i do , its show this msg