look at the Week() in the studio documentation. Anthony Petruzzi Webmaster 954-321-4703 http://www.sheriff.org
-----Original Message----- From: CF_JONNY [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 11:23 AM To: CF-Talk Subject: UDF<>Dates and week numbers 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 ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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