I am using libre base and libre writer. When i use date fields from the database in the mailmerge the day component increases by two days. The month and year components of the dates are not changed. The fields in the database file are all in DATE format. Another strange thing is that when the database fields are VARCHAR from the inception of the table the date is brought into mailmerge correctly. However if the table was built with DATE format and then edited to VARCHAR as a workaround the date still changes by two days. Any help much appreciated. Have transitioned to base from spreadsheets with large data sets .thank you
But see also - tdf#168919, which talks about the same problem in 25.8.2.2 (at least that’s what was mentioned in the metadata there); so we need to know the version to tell for sure.
1 Like
Hi Mike
I loaded an update of 25.8.2.2 last night and got the chance to run a few tests with mailmerge and dates and they all worked fine. I was so relieved and delighted - so thank you to you all for your help. I will do more work with it this morning and will let you know if I hit any snags.
John
Thank you. loaded 25.8.2.2. and on a couple of tests it seems to be solved.
John