#1   Report Post  
Old April 25th 08, 12:19 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2008
Posts: 1
Default Date problem YYYYMMDD

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

  #2   Report Post  
Old July 7th 08, 04:39 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 13
Default Date problem YYYYMMDD

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

"Hilco van Olst" wrote:

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
date in the form of yyyymmdd kang New Users to Excel 2 October 11th 07 05:19 PM
Formatting a date as yyyymmdd + ## Steve Excel Worksheet Functions 6 August 24th 07 04:06 PM
convert date (YYYYMMDD) to weeknumber mark paul Excel Worksheet Functions 1 February 27th 07 12:05 PM
I need a yyyymmdd date format with no dashes EXCEL HELP PLEASE Excel Discussion (Misc queries) 2 December 21st 06 08:19 PM
Is there an Excel date format as follows: yyyymmdd? N Excel Discussion (Misc queries) 3 June 22nd 06 09:44 PM


All times are GMT +1. The time now is 09:34 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017