I have a financial reporting database which produces reports on a fiscal year basis. Our fiscal year is from June thru July. We completed our 1st fiscal year at the end of June ’19 and began our 2nd fiscal year on July 1st. Throughout the first fiscal year, my query calculated FYTD values by simply using the following expression in the Date field; Between #7/1/2018# And [Enter Reporting Month]. Here’s the problem …. Now that we’re in our 2nd fiscal year, I need to replace the static value of #7/1/2018# with the appropriate fiscal year begin date – based on the value entered in the “[Enter Reporting Month]” field. For instance, if the reporting month entered is between 7/1/2019 and 6/30/2020, I need the beginning fiscal date to be 7/1/19; if the reporting month is between 7/1/2020 and 6/30/2021, the fiscal year begin date should be 7/1/20, etc. Any help is greatly appreciated