[Solved] Dates pre 1800 display as 01/01/1800

Creating and using forms

[Solved] Dates pre 1800 display as 01/01/1800

Postby rhammer54 » Sun Jan 12, 2020 8:14 pm

How do I configure my forms to display dates pre-1800. The table (external MySQL) has the dates formatted correctly and display correctly in Base. But when I create a form the dates pre-1800 are all displayed as 01/01/1800.
Last edited by rhammer54 on Mon Jan 13, 2020 8:26 pm, edited 1 time in total.
OpenOffice 4.1.5 on Windows 10
rhammer54
 
Posts: 12
Joined: Sat Jan 04, 2020 1:52 pm

Re: Dates pre 1800 display as 01/01/1800

Postby UnklDonald418 » Sun Jan 12, 2020 8:22 pm

Open the Properties Date Field dialog for the form control.
On the General tab change Date min to include your dates.
Be aware there are some inconsistencies in early dates.
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.7 & LibreOffice 6.1.5.2 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 1296
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: Dates pre 1800 display as 01/01/1800

Postby rhammer54 » Sun Jan 12, 2020 8:36 pm

Thanks for the quick reply. I have managed to get the date down to 01/01/1600 minimum and this works, however I have dates in the 1500's I need to display. The database I am working on is for genealogical / historical records. Is there any way to get around the minimum 1600 limitation?
OpenOffice 4.1.5 on Windows 10
rhammer54
 
Posts: 12
Joined: Sat Jan 04, 2020 1:52 pm

Re: Dates pre 1800 display as 01/01/1800

Postby Villeroy » Sun Jan 12, 2020 8:48 pm

Replace the date control with a formatted control and apply some date format. This behaves similar to a spreadsheet cell.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28220
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Dates pre 1800 display as 01/01/1800

Postby RoryOF » Sun Jan 12, 2020 8:55 pm

Add remember the shift between Julian calendar and Gregorian calendar.
Apache OpenOffice 4.1.7 on Xubuntu 18.04.4 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 30933
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Dates pre 1800 display as 01/01/1800

Postby UnklDonald418 » Sun Jan 12, 2020 9:02 pm

I seem to recall a discussion of the issue here on the Forum, but it was some time ago and I haven't been able to locate it.
There is a discussion of some of the issues surrounding dates in
Chapter 6.6. Problems with dates of Andrew Pitonyak's book "OpenOffice.org Macros Explained OOME Fourth Edition" which can be downloaded from
http://www.pitonyak.org/oo.php
The database is storing an ISO date, but in 1582 many countries switched from a Julian to a Gregorian calendar, which confuses the ISO dating system.
If you don't need to do any date calculations, it might be easier to save those dates as text.
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.7 & LibreOffice 6.1.5.2 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 1296
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: Dates pre 1800 display as 01/01/1800

Postby RoryOF » Sun Jan 12, 2020 9:05 pm

UnklDonald418 wrote:The database is storing an ISO date, but in 1582 many countries switched from a Julian to a Gregorian calendar, which confuses the ISO dating system.
If you don't need to do any date calculations, it might be easier to save those dates as text.


And there is considerable variation in the adoption date - England/Wales 1752 and Russia 1918.
Apache OpenOffice 4.1.7 on Xubuntu 18.04.4 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 30933
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Dates pre 1800 display as 01/01/1800

Postby Villeroy » Sun Jan 12, 2020 9:08 pm

RoryOF wrote:Add remember the shift between Julian calendar and Gregorian calendar.

Dates between 1582-10-05 and 1582-10-14 are invalid. 1582-10-04 is followed by 1582-10-15. This was the Vatican's implementation of the new Gregorian Calendar.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28220
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Dates pre 1800 display as 01/01/1800

Postby RoryOF » Sun Jan 12, 2020 9:10 pm

Protestant England/Wales didn't change until 1752, as the calendar shift was regarded as "a fiendish Popish plot"!
Apache OpenOffice 4.1.7 on Xubuntu 18.04.4 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 30933
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Dates pre 1800 display as 01/01/1800

Postby Villeroy » Sun Jan 12, 2020 9:17 pm

I think it was the only time in history that the Vatican was avantgarde.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28220
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Dates pre 1800 display as 01/01/1800

Postby rhammer54 » Mon Jan 13, 2020 12:07 pm

The database I am connected to is external MySQL which the date field is configured as DATE. My tables in Base connected to this database reads the dates correctly right back to the earliest which are in the 1500's. So is there a way I can manipulate the dates from the table so that they display correctly in forms and reports pre 01/01/1600?
Sorry but I have only being using Base for around 2 weeks and am struggling here.

On the other discussion re julian and gregorian calendars - the complication as well was that in the UK at least the year changed end of March in the julian and end of december in the gregorian - luckily I don't need to do any calculations - just need the date presented correctly in forms pre 1600.

Thank you for all you replies, all are appreciated - Bob
OpenOffice 4.1.5 on Windows 10
rhammer54
 
Posts: 12
Joined: Sat Jan 04, 2020 1:52 pm

Re: Dates pre 1800 display as 01/01/1800

Postby RoryOF » Mon Jan 13, 2020 12:26 pm

I found a Julian date calculator at https://keisan.casio.com/exec/system/1227779487#! I hope it is of some use to you.
Apache OpenOffice 4.1.7 on Xubuntu 18.04.4 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 30933
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Dates pre 1800 display as 01/01/1800

Postby rhammer54 » Mon Jan 13, 2020 1:04 pm

I have half solved the problem.
If I create my form as per normal and retrieve dates pre 1600 then they display as 01/01/1600.
If I edit my forms date field and replace the fields property Date with Text then a date - for example 22/12/1547 displays as 22/12/47.
The unsolved half of the problem is that the decade part of the year has been truncated. I cannot see where in Base or OO I can change the format. Tools --> Options doesn't help.
OpenOffice 4.1.5 on Windows 10
rhammer54
 
Posts: 12
Joined: Sat Jan 04, 2020 1:52 pm

Re: Dates pre 1800 display as 01/01/1800

Postby rhammer54 » Mon Jan 13, 2020 4:01 pm

I have found a solution. In the form configure the date field as 'Formatted Text', then set the formatting property to Date --> 31/12/1999. The form now presents the date in the correct format for years before 1600.
Yippee :D :D :D
Bob
OpenOffice 4.1.5 on Windows 10
rhammer54
 
Posts: 12
Joined: Sat Jan 04, 2020 1:52 pm


Return to Forms

Who is online

Users browsing this forum: No registered users and 1 guest