Page 1 of 1

[Solved] Date field changing

PostPosted: Fri Jan 01, 2021 10:46 pm
by Georged55
I created an OO data base on 11/13/2005, yes, almost 15 years ago, and have used it every day since as a journal to keep my daily activities. Today is 1/1/2021 & the date will not change. When I set the date field to 1/1/21 it immediately sets itself back to 12/31/20. Is there something in OO that restricts the maximum date in any way? I can't find anything. Is there something I can do to fix this? :?:

 Edit: Split from Maximum Size of a Base Database as the problem is unrelated.
Please start a new topic for a new problem.
 

Re: Maximum Size of a Base Database

PostPosted: Fri Jan 01, 2021 11:56 pm
by FKlusmann
Happy New Year, @Georged55!
I ran across this while looking for something else. Try, from the main Base panel, <Tools> <Options> [Oo or LibreOffice][General] and under "Year (Two Digits)", change the range to a higher value.

Re: Maximum Size of a Base Database

PostPosted: Sat Jan 02, 2021 4:40 am
by Villeroy
FKlusmann wrote:Happy New Year, @Georged55!
I ran across this while looking for something else. Try, from the main Base panel, <Tools> <Options> [Oo or LibreOffice][General] and under "Year (Two Digits)", change the range to a higher value.

By default this setting is 1930. This is the setting which determines if 1/1/30 is meant to be in 2030 or 1930. It does not impose any limit to the entered date.
Georged55 wrote:When I set the date field to 1/1/21 it immediately sets itself back to 12/31/20. Is there something in OO that restricts the maximum date in any way? I can't find anything. Is there something I can do to fix this?
This happens in your input form only, I think. You defined a maximum date for the form control.

Re: Date field changing

PostPosted: Wed Jan 06, 2021 9:49 pm
by Georged55
I can't find anyplace where the maximum date can be changed or specified. I increased the value under Year (two digits) to between 2000 and 2099 and nothing changed. Can anyone specify exactly what I have to do to possible change the maximum date setting. I can't find anything.

Re: Date field changing

PostPosted: Wed Jan 06, 2021 10:41 pm
by Villeroy
Open the form for editing and get the properties dialogue of the date control.
And test if you can enter a record with a recent date directly into the table.

Re: Date field changing

PostPosted: Thu Jan 07, 2021 1:22 am
by Georged55
First thanks for your assistance with this.
I guess there's a lot I don't know including how I created this in the first place back in 2005. I don't know how to open the form for editing so can't get the properties dialogue of the date control. Do I open the .odb file? I open that, select Forms, right click on the file in the Forms section & select Edit. This opens my form. I right click on the Date block but there's no properties in the list. I'm quite confused.

Re: Date field changing

PostPosted: Thu Jan 07, 2021 1:51 am
by Villeroy
No problem. You have opened the form for editing. Now there are 2 glitches:
1) When you click on the date control it may be selected together with its label (if any) because the 2 elements may be grouped. Use Ctrl+Click to select a single element regardless of grouping.
2) Right-click>Control... calls the control's properties dialog whereas right-click>Form... calls the properties dialog for the control's logical form (the data connection to some table or query).
Two of the date control's properties are min.date and max. date. Change them, close and save the form, save the containing database document. There are other ways to impose limits on date input but this is the most likely one.

Re: Date field changing

PostPosted: Fri Jan 08, 2021 1:22 am
by Georged55
Great answer. Was able to locate Date properties. Thanks for helping.