Opening a date field results in string format

[Dannopcs]

Good day, first post, new user.

I have an ACT! database that contains several fields formatted as date fields. When I open up a crystal report that accesses these fields, they are formatted in the report as string fields with no option to format the field as a date.

As a result, the data is shown as 20030101 for 1/1/2003.

Am I doing something wrong? Is there a way to fix this?

Thanks, Danno...
dannopcs@comcast.net

 

[GJParker]

Welcome Danno

I am not familiar with ACT databases but as far as I know CR won't change the format of fields just by adding them directly into the report from the database.

You said the fields are formatted as dates in the database, what are the fields datatype ? String, date or datetime.

If the datatype is string I would suspect this is how they are actually held in the database if they are Date or DateTime take a look in File->Options->Fields tab and check the field format for Date or Date and Time see what format is set for these types of fields.

HTH

Gary Parker
Systems Support Analyst
Manchester, England