Ask Your Question

Date Format Frustration! [closed]

asked 2014-10-15 21:55:41 +0100

leanne.drivas gravatar image

updated 2020-08-02 14:36:00 +0100

Alex Kemp gravatar image

I am trying to do a mail merge based on a collection letter. The address fields work fine, however we need to include an expiration date. We format the database with mm/dd/year expire dates, but when merging the letter, writer switched the format to number format (12345) which will absolutely not work for our letters. We have tried formatting the date in our database (calc spreadsheet) several different ways and it makes no difference how we format the source, Writer re-formats it.

Is there any way to preserve the normal date format, or else set up Writer to format it as a date and not a number???

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-04 23:45:40.470341

2 Answers

Sort by » oldest newest most voted

answered 2014-10-15 22:34:03 +0100

Lupp gravatar image

updated 2014-10-15 22:36:05 +0100

The format for printing values from the database is chosen immediately before inserting the field. Did you choose 'Format' > 'From database' in the dialogue before you inserted the date field? You also may select a format or define one under 'User-defined' > 'Additional formats'. A date is a numeric value and the 'Standard' format for numeric fields is not a date format.

edit flag offensive delete link more

answered 2014-10-16 12:41:08 +0100

Jens S gravatar image

When you create a database-file from the your spreadsheet - 1. row in the spreadsheet is used as field-name and 2. row as field-type. After registration of this odb-file, never touch it again - all addition and deletion should be done in the spreadsheet and will immediately be reflected in the database. If you are sure that all dates in the 'expiration date' - column are dates and that does not solve your problem - you can change all the dates to text by entering a ' in front of the date.(use search and replace)

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-10-15 21:55:41 +0100

Seen: 650 times

Last updated: Oct 16 '14