Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Analysis Server and Reporting Services (2005)  Reporting services, Foxpro and date formats

Author  Topic  Plaice Starting Member 20 Posts Posted - 2010-04-13 : 06:21:25 Unfortunately one of our older databases uses foxpro and have been trying to work with it. Currently working on a report using two of the tables ACTIONS and STOCK. There are two values in ACTIONS that I'm using which are comments and duedate. Duedate is fine as this is in date/time format but the comments is causing some issues. The data within this field is like: "Reschedule from 24/03/10". I've been trying to use CTOD(SUBSTR(actions.comments, 8, 15)) AS todate to format the data in date/time format so I can compare this with the duedate but I'm getting 30/12/1899 00:00:00 for all values. Anyone have any ideas?