[Solved] Date field twisted

Creating tables and queries
Post Reply
IreneEng
Posts: 19
Joined: Thu Jul 27, 2017 10:00 pm

[Solved] Date field twisted

Post by IreneEng »

Happy 2018

I entered "2 Sept 1692" in a date field several times, the value showed as "Sat, Dec 30, 1899" :crazy:

Many dates I've entered prior, showed correctly.
Last edited by Hagar Delest on Thu Jan 25, 2018 10:00 pm, edited 1 time in total.
Reason: tagged [Solved].
Apache OpenOffice 4.1.2
Windows 10 ... I think
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Date field twisted

Post by Villeroy »

IreneEng wrote:"2 Sept 1692"
2 Sep 1692
2 September 1692
2/9/1692
9/2/1692 (in US context)
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
keme
Volunteer
Posts: 3699
Joined: Wed Nov 28, 2007 10:27 am
Location: Egersund, Norway

Re: Date field twisted

Post by keme »

It seems that Base will not accept abbreviated month names in input. You need to type it in full - "September" - or use the month number (with proper delimiters) instead.

You can specify abbreviated month name in the format for the field, but that format is only used for output, not as an "input mask".
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Date field twisted

Post by Villeroy »

A formatted form control accepts the same input patterns as a spreadsheet cell, including "2 Sep" and "2 September" but not "2 Sept"
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
IreneEng
Posts: 19
Joined: Thu Jul 27, 2017 10:00 pm

Re: Date field twisted

Post by IreneEng »

Thank you all!

Mistake corrected :)
Apache OpenOffice 4.1.2
Windows 10 ... I think
Post Reply