Pete -
I only want it to pull from the current fiscal year (from 1 Nov 2013 onward) and it will run monthly and should stop at the end of each full month. So if I ran it March 3 it would give data from Nov - Feb only?
Thank you so much!
Holly
I need to specify in ongoing report to pull data for a fiscal years that run from Nov 1 - Oct 31
Someone in house said to use this - but it's not exactly working - any help would be appreciated!
BeforeReadingRecords;
if month(today) in [11,12] then
date(year(today),11,01)
Else
if...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.