DBF dates for mail merge

Post here those questions, bug reports and suggestions for SoftMaker Office 2018 for Mac that do not fit in any of the application-specific subforums.

Moderator: SoftMaker Team

Post Reply
taccy
Posts: 7
Joined: Tue Sep 11, 2012 5:48 pm

DBF dates for mail merge

Post by taccy » Sun Sep 15, 2019 6:32 pm

I wish to create some labels from a data file. When I save the file (in Planmaker) as DBF the date format changes to a number formatted as yyyymmdd,
which is not recognisable to the (elderly) users of the labels- but Planmaker does not seem to let me reformat the cells to the correct date format.
Is ther any way to do this. I have tried using CSV files -but the labels do not work well with that fomat -just showing mutliple instances of the last field.

Is there an easy way to reformat the DBF date fields? for us in making lables.

Thanks

miguel-c
SoftMaker Team
SoftMaker Team
Posts: 323
Joined: Wed Jun 05, 2019 12:02 pm

Re: DBF dates for mail merge

Post by miguel-c » Sun Sep 15, 2019 8:28 pm

Hi, I created a PlanMaker file with regular dd/mm/yyyy dates (see attached).
I then I saved the file as dbf and opened it in notepad and noticed that in fact they are stored as yyyymmdd there.
However when I assign the DBF in to a TextMaker document, the dates are displayed as dd/mm/yyyy.
Attachments
file.tmdx
(12.86 KiB) Downloaded 2 times
database.pmdx
(5.9 KiB) Downloaded 2 times
database.dbf
(128 Bytes) Downloaded 2 times

taccy
Posts: 7
Joined: Tue Sep 11, 2012 5:48 pm

Re: DBF dates for mail merge

Post by taccy » Sun Sep 15, 2019 11:52 pm

Thanks Miguel, your file showed me that it could be done and meant that I should explore further.
I have got it working, still not sure of the exact process, but it seems to be dependent on opening the initial file in the 'Normal.tdmx' format. On my list the top 'default' option results inusing the dbf nuerical date.
I'm not sure whether the default is something that I have produced or not. Its working and thats what matters.

Thanks again

miguel-c
SoftMaker Team
SoftMaker Team
Posts: 323
Joined: Wed Jun 05, 2019 12:02 pm

Re: DBF dates for mail merge

Post by miguel-c » Mon Sep 16, 2019 12:11 am

I'm glad it worked! It may be related to your Windows regional settings when you created the original file.

Post Reply

Return to “SoftMaker Office 2018 for Mac (General)”