Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

incorrect date when opening a dbf (foxpro) file

When I open a dbf file (foxpro), date appears to be incorrect.

For example: 01/06/2019 17:05:03 becomes 02/06/2019 10:05:02 02/06/2019 21:27:33 becomes 03/06/2019 18:27:32

On both examples the first date/time is correct. I've tried to change date/format settings but I have not been able to correct the date.

Thanks!

incorrect date when opening a dbf (foxpro) file

When I open a dbf file (foxpro), date appears to be incorrect.

For example: example:

01/06/2019 17:05:03 becomes 02/06/2019 10:05:02 10:05:02 and

02/06/2019 21:27:33 becomes 03/06/2019 18:27:32

On both examples the first date/time is correct. I've tried to change date/format settings but I have not been able to correct the date.

Thanks!

incorrect date when opening a dbf (foxpro) file

When I open a dbf file (foxpro), date appears to be incorrect.

For example:

01/06/2019 17:05:03 becomes 02/06/2019 10:05:02 and

02/06/2019 21:27:33 becomes 03/06/2019 18:27:32

On both examples the first date/time is correct. I've tried to change date/format settings but I have not been able to correct the date.

Thanks!

SAMPLE FILES:

C:\fakepath\sample_rename_extension_to_dbf.xls (please change the extension to dbf first, this is the only way I could upload this sample file)

C:\fakepath\sample_file_correct_date.xlsx