Happy Tuesday! I would like to automatically generate the weeks of the year as a number and then have the date automatically come along with it.
Example: 1 - 12-31-01 2 - 01-07-02 3 - 01-14-02 4 - 01-21-02 52 - 12-xxxxxxxx Is anyone aware of a UDF that can return such an animal? Then, I would like to query those results and return a range of the current week and two previous and two following. Any Ideas would be great JON _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists