I have a data field named “Fiscal Year” which stores values in the following text format; FY 2018. Our fiscal year period is from July thru June – with the YEAR portion of “FY 2018” being the fiscal year ending YEAR. For instance, the date of October 2019 is part of FY 2020. Here’s my problem, I have several queries in which I criteria the Fiscal Year field and I’d like to automate that process, based on the month a user selects. Here is the closest I’ve come thus far:
"FY " & DateSerial(Year(DateAdd("m",+6,([Enter Month]))),6,1)
The problem is that this expression returns “FY 6/1/(appropriate year). I only want it to return “FY (space)” and the appropriate 4-digit year; For instance ...FY 2020
Any help is greatly appreciated!!
"FY " & DateSerial(Year(DateAdd("m",+6,([Enter Month]))),6,1)
The problem is that this expression returns “FY 6/1/(appropriate year). I only want it to return “FY (space)” and the appropriate 4-digit year; For instance ...FY 2020
Any help is greatly appreciated!!
