CalcBuilder Forum

Dateformat 'incorrect' despite settings

User Jeff Lafranca 2025-06-09 11:21:23

Dear reader,

I have a Calcbuilder which calculates several dates. Despite the correct settings in the Excel spreadsheet and setting the locale to 'Dutch/Netherlands', and setting the dateformat to dd-mm-yy (which should show as dd-mm-yyyy), it shows as: mm/dd/yyyy. See attached screenshot.

Any ideas as how to correct this? I have added login credentials as well.

Moonsoft support 2025-06-09 12:21:10

Hi,
we have checked the spreadsheet and if we open the cell format we see it with / here. The outputs will try to follow the cell format whenever possible, we have configured the custom format dd-mm-yyyy (file attached), and it seems to work as expected now. Please check the file from your side in order to confirm you also see the right format on the cell.

Best regards
Guillermo V.
Moonsoft Team

...
CalcBuilder

Create dynamic calculators

Buy now!
...
Support/development 40 hours

With the peace of mind of having a professional team at your service (20% discount)

Buy now!