Thanks Dan I will try it. Mike ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 24, 2002 8:57 AM Subject: [CFTALKTor] SQL for Dummies
> > Not sure about Sybase, but in redbrick you would do this: > > select * > from mytable > where date = dateadd(day, -85, '20020423') ; -- or, where date = > dateadd(day, -85, current_date) > > The syntax of the dateadd function varies from database to database, but > this example is probably close. > > ********************* > > I have a CF page that runs on a Sybase SQL server. I need to retrieve > records from the database using the following format 20020423 less 85 days. > Can anyone help me with this statement. > > > - > You are subscribed to the CFUGToronto CFTALK ListSRV. > This message has been posted by: [EMAIL PROTECTED] > To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ > Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ > This System has been donated by Infopreneur, Inc. > (http://www.infopreneur.net) > - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "Mike" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
