General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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.
>To control money amount per month at a shop,
>
> Whats programatically more correct and usual
>
> Create only a table to control all months
>
> Or create a new table every month ?
>
> Jan_2001.dbf
> Feb_2001.dbf
> etc...
>
>
> I've never created this kind of application before
>
> Thanks
>
>
>
>
>
>
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only