What do you mean? current week's dateformat? now() grabs the date and time.. dateformat() formats the date in whatever way you want.. I've always saved formatting for the output..
On Tue, Apr 22, 2008 at 1:58 PM, Nate Willard <[EMAIL PROTECTED]> wrote: > 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 <cf-talk@houseoffusion.com> > 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:304006 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
