Why not just store 4/22, and then do the date computation on the other (recall) side? It'll potentially be a little slower, but unless you have a crapton of data, its probably irrelevant.
cheers, barneyb On Tue, Apr 22, 2008 at 12:24 PM, Nate Willard <[EMAIL PROTECTED]> wrote: > Greg, > > > I think its more complicated than that, but I might be over thinking this... > > > If I want to records weekly and lets say I ran those records today > > > Todays date is 4/22/2008 > > > But, I would need to insert those records into the database as 4/20/2008 > since 4/20 is the start of this week. > > > right? -- Barney Boisvert [EMAIL PROTECTED] http://www.barneyb.com/ Got Gmail? I have 100 invites. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304010 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
