Jump to content
You must now use your email address to sign in [click for more info] ×

Data Merge: Wrong date formatting


Recommended Posts

Maybe this is already fixed? I have to confess, that I am a few betas behind. When I datamerge fields formatted like 31.01.66 they will be displayed as 31/01/66 after the merge. I tested (file attached) with 3 different formattings, but only the version with the dots "failed".

PS: The .xlsx was made in LibreCalc.

dates.xlsx

------
Windows 10 | i5-8500 CPU | Intel UHD 630 Graphics | 32 GB RAM | Latest Retail and Beta versions of complete Affinity range installed

Link to comment
Share on other sites

So this seems to be a LibreOffice issue. Sorry for wasting your time. EDIT: Saving as CSV worked.

libreoffice.jpg

------
Windows 10 | i5-8500 CPU | Intel UHD 630 Graphics | 32 GB RAM | Latest Retail and Beta versions of complete Affinity range installed

Link to comment
Share on other sites

×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.