|
View Full Version : Populating a table with with dates dib 04-17-2008, 09:48 PM I need a table that has all the year dates in a field (e.g. from 01 Jan 2008 to 31 Dec 2008) This means some 365 records! I hardly can type them all Wanted to know how to populate this table automatically. Thanks boblarson 04-17-2008, 09:57 PM Just curious, but what are you using it for? Rabbie 04-18-2008, 03:28 AM I need a table that has all the year dates in a field (e.g. from 01 Jan 2008 to 31 Dec 2008) This means some 365 records! I hardly can type them all Wanted to know how to populate this table automatically. Thanks I don't want to be pedantic but I can't stop myself.:D There are 366 days in 2008 as it's a leap year dib 04-18-2008, 04:00 AM Just curious, but what are you using it for? I want to link through it 2 tables that have nothing in common but dates. By the way Rabbie, I did say some 365, was'nt absolute. :) Rabbie 04-18-2008, 04:44 AM I want to link through it 2 tables that have nothing in common but dates. By the way Rabbie, I did say some 365, was'nt absolute. :) Fair point. I did say I was tryingto control my pedantry:) |