Dates in database column have shifted by one day

asked 2019-05-15 19:08:28 +0200

mgmtp gravatar image

Using LO Base on Windows.

I have a column in a database table that contains dates.

When I reopened it all the dates had shifted back by one day.

What could have caused this?

I have tried changing system time zone to match the one where I created the database, but with no effect.

Is there an easy way I can shift all dates forward by one day? (Not all rows have a date entry)

edit retag flag offensive close merge delete


Please provide basic information - Specific LO version, OS and database being used.

How are dates entered - are they default? Can you duplicate the problem?

Ratslinger gravatar imageRatslinger ( 2019-05-15 21:20:29 +0200 )edit

Version: (x64) Build ID: 86daf60bf00efa86ad547e59e09d6bb77c699acb CPU threads: 4; OS: Windows 10.0; UI render: default; Locale: en-GB (en_GB); Calc: group threaded

Dates entered as DD/MM/YY (not sure what would be default)?

I have downloadeda backup of the database from the day I last know it to have been correct and the dates still show up shifted when I open it.

I've also tried creating a new database with just a date field, which seems to not shift when I open it, although I'm not sure what other testing I could do.

mgmtp gravatar imagemgmtp ( 2019-05-15 22:31:01 +0200 )edit

Unfortunately, as you stated, this did not happen for you on a new DB. Must be something specific in that Base file (still have not specified what DB is used). Probably only way to help fix this problem is if you can post a sample Base file with the problem present and without personal info.

Ratslinger gravatar imageRatslinger ( 2019-05-15 23:02:40 +0200 )edit

It's a HSQL database.

I've made a copy of one of the tables that has dates but no personal info - it's here:

mgmtp gravatar imagemgmtp ( 2019-05-16 09:45:08 +0200 )edit

Please, edit your question and upload the test file there. Foreign links are not welcome here or are ignored.

ebot gravatar imageebot ( 2019-05-16 15:04:59 +0200 )edit

@mgmtp Don't know what you presented in this sample. There are 5 records with dates. Don't see any change with opening or closing of the file. You haven't even given any specific information as to what is expected or what to look for. Based on what you presented there is no problem.

Ratslinger gravatar imageRatslinger ( 2019-05-16 16:40:35 +0200 )edit

The dates have all shifted back from 1 day from how they were entered. Each date should be the first of the month, but on opening showed as the last day of the previous month. I can't figure out why this has happened. I have manually corrected the dates currently in the database but I would like to avoid doing this again if there is a reason for this behaviour.

mgmtp gravatar imagemgmtp ( 2019-05-16 19:35:08 +0200 )edit

Sorry but sample is inadequate to help in that regard. Sample only has a table and it would probably help to see the manner in which the dates were actually entered. Only supposition is some setting in the form or a possible macro causing the problem.

Have not recalled any bug in past years with this type of problem. If the problem cannot be reproduced it is not clear how to determine what caused the problem.

Ratslinger gravatar imageRatslinger ( 2019-05-16 20:03:15 +0200 )edit