[archive] ACUODBC Date Field

[Migrated content. Thread originally posted on 24 August 2006]

I am testing the ACUODBC connection from Crystal reports and have a question about date fields. All of my date fields are comming up as numeric fields in Crystal, this also happens in Excel and Access.

Does anyone know how these fields have to be defined to return them as dates?

Thanks

Have you used the DATE directive in your FD?

[Migrated content. Thread originally posted on 24 August 2006]

I am testing the ACUODBC connection from Crystal reports and have a question about date fields. All of my date fields are comming up as numeric fields in Crystal, this also happens in Excel and Access.

Does anyone know how these fields have to be defined to return them as dates?

Thanks

Thanks for the help and I believe this will work but as soon as I recreate the .xfd file I get the following error message.

Database Connector Error: ?50000:[AcuCorp, Inc.][AcuODBC Driver][ISAM]Vision missing file [Database Vendor Code: 24 ]?

Have verified the index file and the .xfd are in the same directory and the correct directory I am lookin in.

Any suggestions?

Thanks