INTRODUCTION:
The Fiscal Calendar UFL is a Visual Basic developed User Function Library that contains functions for determining the Fiscal Year, Quarter, Month and Week a date falls into. It has been tested with SCR (Seagate Crystal Report) 5, 6 and 7 and SI (Seagate Info) 7.0 or later. It can also be used with Visual Basic, MS Access, ASP, MS Excel and MS Word, just like any other COM Object.  

HOW DOES THIS UFL WORK?
To be able to correctly determine where a particular date falls in a Fiscal Calendar, two questions have to be answered first:

1. What is the starting and ending dates for the Fiscal Calendar Period?
2. How many Weeks are in a Fiscal Month? We use a fiscal month mask to determine the number of weeks in a fiscal month.