Hi,
I can export the customer database into a CSV file without any trouble. The CSV file loads into the editor and displays perfectly. However, if I load the file into Excel, some of the date formats are displayed as dates eg mm/dd/yyyy and are treated as dates by Excel, whilst other dates are loaded as mm-dd-yyyy and are treated as text fields. Why?
Is there another CSV editor that I could use to do the data crunching to avoid this issue??
Thanks for your help,
Ed
CSV File format
CSV File format
Thanks Scott, I ended up using MS Access. Unfortunately the date format comes through as text and then has to be converted manually to a date format before I can use it.
Got though,
Cheers, Ed
Got though,
Cheers, Ed
-
- Active Member
- Posts: 108
- Joined: Mon May 12, 2003 12:24 am
- Location: Nagasaki, Japan
Same problem here. I use excel to filter out my database mailers and wish there was something that coould be done about the dates. The biggest problem with them as test is that say I wanted to get all the orders from Jan 2005 that were still in the history. They are all grouped with the 2006 orders.
1/5/2005
1/5/2006
1/6/2005
and so on. Dont soppose there is any way to fix it is there?
1/5/2005
1/5/2006
1/6/2005
and so on. Dont soppose there is any way to fix it is there?
The problem is that Excel auto-formats what it thinks are dates into that format. I guess we could output a raw date # field (days since 2000) and you could sort on that. The only problem would be is you would need to know what ranges to filter from.
We are in the process of releasing an update so any quick suggestions might make the cut.
Scott
We are in the process of releasing an update so any quick suggestions might make the cut.
Scott
Date Format
Hi Scott,
Personally I would like the same starting point as Excel, eg Day 1 is January 1st 1900, and then the date is expressed as days since then. This would make it very easy from any stand point as it can be formatted in any way by any application.
Is anyone else happy with this solution??
Cheers, Ed
Personally I would like the same starting point as Excel, eg Day 1 is January 1st 1900, and then the date is expressed as days since then. This would make it very easy from any stand point as it can be formatted in any way by any application.
Is anyone else happy with this solution??
Cheers, Ed
-
- Active Member
- Posts: 108
- Joined: Mon May 12, 2003 12:24 am
- Location: Nagasaki, Japan
Date Format
I would have to say that my preference would be to have a day count from 1900 onwards, solely because this is how Excel handles dates, and I use excel to do all my number crunching.
Cheers, Ed
Cheers, Ed