Apache OpenOffice (AOO) Bugzilla – Issue 128300
Date formatting problem with MMMM
Last modified: 2020-03-05 19:33:53 UTC
When using the MMMM date format the data input gets changed to random date formats ie- different months all ending up as the same month or a ddmmyy format i'm trying to create an MMMM formatted list box in a form. the list box is based on a small table just for the months of the year. Its really annoying or am i doing something wrong? Cheers Bill Forder
Your bug report is being closed as NOT_AN_ISSUE due to a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information: a) Provide details of your system including your operating system and the latest version of AOO that you have confirmed the bug to be present b) Provide a step-by-step procedure to reproduce (the simpler will be the better) c) Provide any test case(s) which will help us confirm the problem (like a sample document) d) Provide screenshots of the problem if you think it might help e) Read all comments and provide any requested information Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue.
Hi I am running version 4.1.7 Base on windows 10 Home version 1909 My aim is to create a "MonthList table" for use as a list box in a form that has 6 MMMM formatted fields in its corresponding table. I have tried setting a primary key to the Month field (MMMM format) in the table - and setting a separate ID field primary key (integer format) with auto entry. both ways end up producing "December" when I attempt to input the Month names whatever month I enter into the Month field in data entry mode. On the surface of it it looks as tho the example given in the date format options box has somehow become a fixed default and can't be overwritten. Causing December to always appear after moving the focus. The only way I am able to get a workable form is to not employ the Date format and use text VARCHAR instead which presumably means that I will not be able to use date based queries. Please find attached Photos
screen shots will be illegible if I have to shrink them that small
How about uploading the base file with test data? Which formats do your Screenshots have?
None attached files In the absence of a document, it is difficult to reproduce what you describe. Set temporarily as irreproducible. Feel free to reopen once you provide required information.