Cannot modify a field of Date type to be 'Required'

How do I?
1

Hi! I have an optional Date field in my table in Dev environnement. I want to modify the table in order to set the Date field as “Required”.
I removed all the data in the table so the table is empty.
When I want to save my modification, even if the table is empty, i am asked to set value to existing records.

image
image488×352 14.1 KB

I tried many combination of Value: 2025-03-08, ‘2025-03-08’, 08-03-2025 … without no success, I keep having the following error:
Failed to execute SQL : Error 1292: Incorrect date value: ‘’ for column ‘DateFacturation’ at row 1
image
image735×235 12 KB

Can you tell me what is my problem ? Thanks!
Jean

2

Hi Jean,

This was an issue on our side and we have already fixed it. As a work around for the moment are you able to set the field as required at the form-level rather than the table-level? This will ensure the field needs a value before it can be saved.

Kind regards,
Jo

3

Hello Jo-Anne, yes I did set the field as required at the form level. So is this mean the issue will be fixed in the next Five Software release? For my information, is there new releases on regular basis? or only when necessary? is there a way to know when a new release is deployed? Thank you!
Jean