You are replying to:

1. • 
   • Tom
   • Posted on Wed 1 Feb 2006 02:59 PM

   Instead of @today try this out @TextToTime(Today)

   found this somewhere on the net but haven't used it yet. The example was

   SELECT ((@TextToTime(Today) - CREATIONDATE)/86400)

   cheers Tom

Your Comments