Gualtiero and Dave thanks for your help I have resolved the issue with both your tips.
Thank you for your time again Mark > "Date" is possibly(probably) a reserved word? Even if it isn't, your test > will fail when the year rolls over - you should test yyyy/mm/dd. And I > think you might need apostrophes around today's formatted date? > > None of this is guaranteed, I am famous for being wrong. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284795 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4