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)
