Ian,
Great point about the years, I feel silly for not think of that. Can anyone recommend a way to obtain the current week's DateFormat for inserting into the DB? Thanks ----- Original Message ---- From: Ian Skinner <[EMAIL PROTECTED]> To: CF-Talk <[email protected]> Sent: Tuesday, April 22, 2008 11:32:33 AM Subject: Re: Storing Records Weekly in the database - Ideas on how to record the week Nate Willard wrote: > Hello, > > > I'm working to build a system that stores a set of records every week. Can > anyone offer suggestions on how to best save these records in the DB? > > > Should I have a column 'datetime' and have the result be the Sunday of the > week, for example this week's records all with the datetime: 4/20/2008 > > > or Should I use CF's Week() function and store the week number, which I > believe is currently 17. > > > I'm looking for your advice to prevent issues when I want to access the data > later down the road. > > > Thanks > N My feeling would be to store the date as a date. That allows you the most latitude in accessing this data as requirements change over time. If you store the week you would also need to store a year assuming you will eventually have data from more then one 'week 17' as the years go by. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:304002 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
