Date problem YYYYMMDD

H

Hilco van Olst

We have a problem with excel 2007 NL ;

a date format used as YYYYMMDD is treated as a date format as YYYYDDMM.

When i import a file with a date : 20080405, this is treated as 4th of may
2008 (this should be : 5th of april 2008)
The date 20080513 gives an error

If I'm trying the same in Excel 2000 or Excel 2003, the date is treated the
right way.

I'm using :

Windows server 2003 X64 as a terminal server, with Office 2007 standard NL
 
V

Vladimir

If you use the following macro
Code: 
Sub ReopenFile()
fileName = Application.ActiveWorkbook.FullName
Application.ActiveWorkbook.Close
Application.Workbooks.Open Filename:=fileName
End Sub

it will reopen the active DBF file with the correct date conversion. Hope
this will help...

Original idea from http://forum.foxclub.ru/read.php?29,326842,page=2
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel date format YYYYMMDD 1
Access 07 import yyyymmdd 1
Convert text to Date 26
import text file yyyymmdd into date field 3
How to reset incorrect date format after reinstalation of Window X 3
Date format on exporting query to csv file from access 2007 3
Text File Import Fails on YYYYMMDD data field, worked great in Acc 3
Type Conversion with Date formatted as YYYYMMDD 10

Top