Forum Discussion

GeoffBarrenger's avatar
GeoffBarrenger
Qrew Captain
1 month ago

Check Date against a range of dates in another table

I'm trying to take a date of an event, and return the name of the Fiscal Period that date falls within, from another table!! Here's the scenario. A transaction happens in Table A.  The date of the ...
formula query
MarcDouglas's avatar
MarcDouglas
Qrew Member
1 month ago

To be more explicit about the boundary conditions:

var text qryFirstOfMonth = "{6.OAF.'" & Date($FYStartYear,10,1) & "'}";

var text qryEndOfMonth = "{6.OBF.'" & ($endOfMonth + Days(1)) & "'}"; // Add one day and use "before" instead of "on or before"

Or alternatively, ensure your End Date field in the Period table is set to the last second of the period (e.g., "5/23/2026 11:59:59 PM") rather than just the date.