I was wondering if anyone had a better way to compare the date to the fiscal year. For example, I'm building a form that allows employees to submit receipts and cost to be reimbursed. I would have two fields - receiptDate and receiptCost. These two fields are in a collection and a field outside of this collection does =sum(collection.receiptCost) for total claims.

Every year in the month of January - there may be submissions of a December (of the previous year) purchase that is reimbursable until January 31st of the current year. I'd like for them to submit all receipts, whether it's in the last calendar or the current calendar year but be able to calculate and split the reimbursement out to two additional fields - one for "last calendar year reimbursement) and one for "this calendar year's reimbursement".

There's only a max of $1000 reimbursement per calendar year and this is the reason why we have it split up so they can maximize the reimbursement claims.

I'd appreciate any feedback on the logic that needs to be applied to the date/month in the calculated field for the collection of items.