| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 1/19/2009
Posts: 32
|
Hi Bruce,
Every time I export data from Stockfinder and open the CSV file in excel I get a consistent problem with the date formatting. When I convert the date column to a date format, only a fraction of the rows convert correctly. For some reason excel wants to interpret some rows in the DD/MM format and some in the MM/DD format. I can't really see a pattern, but a specific example is that from January 3 2011 to January 12 2011 excel interprets stockfinders data as DD/MM but from January 13 to 2011 to January 31 2011 MM/DD.
I've been using a workaround which is acceptable but time consuming, but I thought I would check in with you to see whether there is something that can be done.
Is this a known problem? Is there a solution? Am I just doing something wrong?
Thanks
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
I can't reproduce this at all. The export seems to be in MM/DD/YYYY format and my Excel gets the dates right every time.
It should probably be noted that my Locale is set to English (US) when I check the formatting of the Column in Excel. If your default Locale is set to something with DD/MM/YYYY as the standard date format, Excel might use that when it can and only be using MM/DD/YYYY in cases where the default date format for the Locale just doesn't work.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 1/19/2009
Posts: 32
|
Thanks Bruce, my locale was not set to US English. It is now and has resolved this problem.
cheers!
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |