Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
>
>
>
>
>
>
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement