Description: Dates that are entered in a form, in a "date field" control with a "date min" property assigned, if they are lower than that date, they are modified without warning the user. Steps to Reproduce: 1. Create a table with at least one DATE field 2. Create a form to edit such table, with a "Date field" control to modify the DATE field. 3. Modify the date field control to assign a "Date min" property (or leave the default 1/1/1800) 4. Save the form 5. Open the form to fill data 6. Introduce in the date control a date lower than "Date min" assigned in step 3 7. With the cursor in the date field, click on "Save record" button on the Form navigation tool bar 8. Close the form and test data in the table Actual Results: On step 7, if you have an autovalue field, it is assigned a new value to it, making it appear that the record has been saved correctly. The date introduced seems as it has been saved (without any modification). The real date saved in the table is the "Date min" date. Expected Results: On step 7, a warning message about the invalid date. No data saved until date is in range. Reproducible: Always User Profile Reset: No Additional Info: Version: 7.4.0.3 (x64) / LibreOffice Community Build ID: f85e47c08ddd19c015c0114a68350214f7066f5a CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL
Created attachment 181991 [details] Test database Database with a table and a form to test. Record with id = 10 has been obtained introducing the date 21/1/1770
Component changed to UI because it seems a control problem, not a Base problem
Same behaviour in version 3.3: LibreOffice 3.3.0 OOO330m19 (Build:6) tag libreoffice-3.3.0.4
Confirmed with: Version: 7.4.0.3 / LibreOffice Community Build ID: f85e47c08ddd19c015c0114a68350214f7066f5a CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded