LibreOffice Base Form with subform date dropdown (default 14th Feb 2019)

[BrianStew]

I have a database which uses a form with subform in which a date can be entered.
The form contains a date field in the main form with a dropdown. Clicking this shows a calendar centred on today’s date (fine - as it should be).

The form also contains a subform with another date field. This also has a dropdown box for it’s date (edit form, right click date field, select column from list, select dropdown yes).
In the subform the date always seems to be centred on 14th Feb 2019 rather than today’s date. This is inconvenient as I usually want to enter a date close to today’s date.
I’ve searched “LibreOffice Base 14th Feb 2019” and can only see “On February 14, 2019, the primary LibreOffice development focused on the upcoming version 6.2”.

Is there a way to centre the calendar on today’s date that I’m not aware of.

I have created a sample database which shows the problem - just trying to figure how to attach it with screenshots.


Test.odb (10.8 KB)

[Villeroy]

Remove any default value from the date control properties.

[BrianStew]

I’ve managed to upload screen shots and “think” i’ve uploaded the test database.
I’m not aware of any “default value from the date control properties”.
There’s certainly no default value for date.

It seems like i’m unable to upload the external fdb file.
I’ve re-created it as an HSQLDB embedded.
Test1.odb (11.6 KB)

[CRDF]

@BrianStew

and “think” i’ve uploaded the test database

As it is external, cannot be opened, nor Form Design’s seen.
?

[RobertG]

@BrianStew : Add also the file testdb.fdb from your desktop. Then we could have a look at the database without any problem.

[BrianStew]

The previous was a firebird external and I didn’t realise that the actual external file wasn’t present.
(Not used external before yesterday).

I’ve re-created the database as a HSQLDB embedded database and the behaviour seems to be exactly the same.

Test1.odb (11.6 KB)