Hi all thanks for the replies, figured it out with this formula where $setDate is the date of the event happening - and I bring in the "Fiscal Period Label"
Your options were great, but unfortunately because it's not always a certain number of days, but a variable based on weekends...I needed to have a table with the Fiscal Periods listed. Luckily our finance team was able to provide!
| FY and Period Label | Fiscal Year | Period | Start Date | End Date |
| FY27 - P02 | FY27 | P02 | 4/26/26 | 5/23/26 |
| FY27 - P03 | FY27 | P03 | 5/24/26 | 6/27/26 |
ToText(GetFieldValues(GetRecords("{9.OBF.'" & $setDate & "'} AND {10.OAF.'" & $setDate & "'}", [_DBID_Fiscal_Calendar]), 6))
