>Moises,
>
>In addition to what George said, some people store a "Fiscal Period" rather than storing a date. We use something like 200101 which is an integer. It would be pretty easy to go from a receipt date to the fiscalperiod with something like
>
>
VAL(LEFT(DTOS(dMyDate), 6))
or
YEAR(MyDate) * 100 + Month(MyDate)
.
>
>That way in your reporting you only have to group on FiscalPeriod.
>
>If the fiscal year starts in July, as some American companies do, you can call the period "CalendarPeriod" and have a table that maps fiscal to calendar periods.
Hi Cindy,
Given that I deal a lot with fiscal months and years, I should've caught this possibility. In these situations, what I do is have a table containing the month name, and the starting and stopping dates for the period. I then use a query utilizing BETWEEN to retrieve the applicable information. Since I still need the date field, this allows me to utilize that, rather than having to populate an additional field.
George
Ubi caritas et amor, deus ibi est