Hi, im currently using Crystal Reports 9 to query DBText which all works fine until it comes to querying a field in the database which is set to autodate (on record create) but Crystal reports every record on the report with todays date. Any ideas?

Does the Automatic Date field have "Both Date and Time" selected in Maintain>Edit Textbase Structure in DB/TextWorks?

If so, the default field mapping is to TIMESTAMP. Perhaps Crystal Reports treats TIMESTAMP as today's date/current time.

You might try changing the [ODBCFields] section of the textbase .ini filed to say:

[ODBCFields]
fieldname,D

or

[ODBCFields]
fieldname,X

The first maps the fieldname to an ODBC DATE field, the second to an ODBC TEXT field.

You can still do date searches on an ODBC TEXT field, but you have to use DB/TextWorks syntax and enclose the criteria in quotes:

SELECT * FROM TABLE WHERE AUTODATE = '1999 : 2006'