Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to create a particular filter in nprinting: the extraction should go from the last month of two FY preceding the month just ended (e.g. if it is February 2, 2021, the month year to be selected is from March 2019 to January 2021. If it is May 2, 2021, the month year to be selected is from March 2020 to April 2021. If it is April 2, 2022, the month / year to select is from March 2020 to March 2022).
FY is fiscal year and the end of the fiscal year is always march.
How can I do?
Thank you
Hi,
This question has a lot of information missing and does not allow us to answer it in100%. I will try to guide the conversation so we can extract all the required info:
Understanding exactly how your calendar is build and data types of the fields used is critical to provide you with the solution. The reasons behind it are due to the fact how Date & Time function work vs Text and Number function. There can be significant differences in the way how expression need to be built.
more about date filtering in my posts here: