Mike that's a good point to note...
-----Original Message----- From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Mike Kear Sent: Monday, 23 February 2009 6:07 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Creating a Date Range The other thing to consider is that while his current need might be to find the records for a specific month, if he hands the function a start date and an end date, that same code can be used for other intervals than just the current month - e.g. this quarter, last year, first half of the year etc. Taking that approach will make the function more likely to be useful for as-yet-undefined purposes. Experience has taught me that any time you define a function closely, and build it to meet the narrow requirements of that definition, Murphy's Law says someone will want to add a new use for the function as soon as you claim the job is 90% finished. (Unfortunately, the corollary is also often true - any time you provide for as-yet-unnamed future functionality, Sod's Law says it's one function that'll never be called for in the future. So you have to make your choices and take your chances.) Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---