database dates

I am wanting to know if anyone has an example of a database to show how you can make a daily entry for each day of the year. Example(hit counter)

Or if someone can give an explanation on how I would make my field entries for the tables

You'll want to make a database based upon Julian dates - the three digit number of days since January 1st of the year.

Example of using ASP and Julian dates is at

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=7627&lngWId=4

You'll need a db with 366 entries and have to include some logic for handling leap years.

I'd make a "Date Dimension" table, with one record for each day of the year. Then, you have a field for each additional attribute you want to track. In your case, they would be Week_No and Month, but you could also add other attributes later if you wish, like Day_Of_Week, Weekend (Yes/No), Holiday (Yes/No), Fiscal_Quarter, etc. etc.

Link your entry table to the Date table using the date field, and you can easily add up the entries by week, month, quarter, day of week, or anything else you'd like to track.