When copying/exporting a DBF file into Excel, date fields copied in

[rkm500]

Hello experts,

When we copy or export a .dbf file into MS Excel, dates from any date field data are exported in Excel worksheet but in the format like '30-Jan-03', '07-Feb-03' whereas it should be copied in American Date format exactly as it appears in .dbf file such as '01/30/03' or '02/07/03'

Please help me if anyone knows the solution of this problem as it becomes very much annoying.

Thank you.

Raj

 

[rob444]

The date format can be easily changed in Excel.

Rob.

 

[mkrausnick]

If you don't actually need the Excel column to contain a date type value (i.e. you are not using the column for any date-related formulas) output a character expression for each date instead, like this:
'dtoc(mydate)' instead of 'mydate'.


Mike Krausnick
Dublin, California