Save as CSV is not exporting my formatted dates correctly

dschast · Newbie Joined: 01 Mar 2006 Posts: 1

I have formatted my dates a certain way on purpose (I'm importing this CSV into a database). I need the dates in a specific format. However, even after changing the format in OpenOffice 2, It is still exporting that field in a different format when I save it as a CSV.

I assume this is because of the way formatting works (its meant to change the display, not the data), but I need it to change the data. Does anyone know how to accomplish this?

Thanks

denmarks · Posted: Wed Mar 01, 2006 1:57 pm Post subject:

Formatting is lost when a date is saved as CSV. You can try the following. Insert this formula to the right of the cells with the dates. =TEXT(A1;"MMM D, YYYY"). Change the formatting and cell reference as desired. This will create a text field based on the original date that will save okay in a CSV file.
_________________
Dennis Marks

probe1 · Posted: Wed Mar 01, 2006 2:57 pm Post subject:

Date cells from Calc exports according the "Locale setting" (in: Tools->Options...->Language Settings->Language).

Which date format you would like? You can change just for export...
_________________
Cheers
Winfried
My Macros
DateTime2 extension: insert date, time or timestamp, formatted to your needs