Populate a new fiscal year field using the date field

Darren1 — Wed, 21 Dec 2022 19:45:45 GMT

My goal is to populate the new [report_date_fiscalyear] field using the [report_date] field. Is this something I can create in the Load Script?

If a date falls between July 1, 2022, and June 30, 2023, the [report_date_fiscalyear] will populate with 2023
If a date falls between July 1, 2021, and June 30, 2022, the [report_date_fiscalyear] will populate with 2022
If a date falls between July 1, 2020, and June 30, 2021, the [report_date_fiscalyear] will populate with 2021
Etc.

I tried using the IF() function but could not find an expression to allow 3+ fiscal years. The function failed when I added additional fiscal year expressions. I'm assuming this is because the "or" function is Boolean. Thanks in advance!

Re: Populate a new fiscal year field using the date field

Darren1 — Fri, 23 Dec 2022 19:12:38 GMT

Solved it! I used the IntervalMatch() with the report_date. When I add the report_date_AGOLfiscalyear field to my table, it displays the correct amount of records along with their fiscal year.

topic Re: Populate a new fiscal year field using the date field in App Development

Populate a new fiscal year field using the date field

Re: Populate a new fiscal year field using the date field