loop over the results of DateDiff("datepart", "date1", "date2"), adding a
date using dateadd() for each iteration.> -----Original Message----- > From: Stephen Moretti [mailto:[EMAIL PROTECTED] > Sent: 01 March 2004 14:09 > To: [EMAIL PROTECTED] > Subject: [ cf-dev ] Quick way to insert a record per day. > > > I've got a start date and an end date and I want to insert a > record into > the database for each date between and including the start > and end dates. > > Any thoughts on a quick and easy way to do this? > > Stephen the fuzzy brained. > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] For human help, e-mail: > [EMAIL PROTECTED] > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
