Exporting from Crystal XI to ODBC - Date/Time value

[jhowardcarter]

Hi,

When exporting a date/time value (style: system default short format) from crystal to a SQL table (which by default creates a new table), I'm loosing the seconds value of the date time. eg 28/07/2009 09:01:13 becomes 28/07/2009 09:01:00. When crystal creates the table, and the field properties, it sets the SQL data type to DateTime.

The export process from Crystal is File>Export>Export Report>ODBC...

I'm requiring a date difference between two time fields, and need this to be as granular as possible.

Can anyone assist me with a solution?

Regards.

 

[Madawc]

You might try changing the data to text, use ToText and format the date the way you want it. Hopefully the export will view this as a sting and leave it alone.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP