General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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,
Some of my data comes in with the FiscalPeriod assigned already, so I'm more likely to use that than derive it from a date. The actual date is only of secondary importance for me.
In any case, this will give Moises some ideas for his design.
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