Requesting info on Normalizing Date fields

[thechazm]

Good Day All,

I am looking for some good information on how to properly normalize dates in access. I have read many things and have actually normalized dates before in the past but I can't help but feel that there is a specific correct way to accomplish this without having to jump through many hoops on coding and query design.

Does anyone have any good online references or some examples I could look at and verify my current situation?

I appreciate the inputs,

Thanks

 

[spikepl]

What are "normalized dates"?

 

[thechazm]

spikepl I know your going somewhere with that question but instead of storing a date/time field in a main table you would use the Id number from a secondary table that would just store dates and in the main table it would only store a number relative to the actual date.

I'm sure you knew this but maybe I asked the question wrong.

Thanks

 

[spikepl]

The question is what it is - I did not know what a "normalized date" was.

I am not aware of any date-specific treatment involved in normalization of data.

 

[thechazm]

Thanks you actually answered my question with your statement:
<I am not aware of any date-specific treatment involved in normalization of data.>

I appreciate the inputs.

 

[jdraw]

see http://www.accessforums.net/database-design/normalization-dates-13530.html

You may have a specific application in mind where this may be an issue.
But the answer in this link is typical in my view.

 

[thechazm]

Appreciate the secondary info jdraw.

 

[thechazm]

Most of the applications that I have built if the table grows several thousands of records every day then I typically will pull the date out of the main table and have it referenced but only for filtering speed. It's far faster to filter 1 million + records on a date field if it's just referenced but I hear your point.

I always liked the saying "Normalize till it hurts, De-Normalize till it works"

Thanks for the great comment and perspective.