Question

Incorrect creation time of files

Laserfiche

Updated December 7, 2020

asked on October 30, 2018 • Show version history

Where does Laserfiche get the date and time the document was created?

The time of the server is 14:36, but Laserfiche creates the document with time of 15:36. 1 hour later.

On volume, the files are with the correct time

Daylight saving time here in Brazil will only start on November 4th.

The database is a Sql Express on the same machine.

1 0

Replies

replied on January 4, 2019

I'm having the same issue. I'm curious if you found a solution?

0 0

replied on February 25, 2019

Also curious about this, have a client experiencing the same issue of the created/last modified times being 6 hours off.

0 0

replied on February 12, 2020

Any news about that? We have a customer with the same issue.

0 0

replied on December 4, 2020

We have a customer with this same issue. No answer from Laserfiche?

0 0

replied on December 4, 2020

I always thought it was the SQL server time?

0 0

replied on December 4, 2020

The value is stored in the SQL database, but most date time values are stored in UTC and translated by the client application into the user's timezone. If you are seeing a discrepancy, I would start by making sure all of the machines in the solution have up-to-date definitions for timezones and especially DST rules.

0 0

replied on December 4, 2020

Here in Brazil the DST was cancelled last and this year (right now it was suposed to be on), I guess this has something to do with this issue. I've checked the server and client machine's configs and DST is turned off. The hour on Windows is displayed correctly but on LF Client (on the server and on a regular PC) the creation date time is shown with +1 hour (example: I've created a new folder on 14:30h but LF client creation date shows 15:30h). How can I check these definitions for timezones and DST rules?

0 0

replied on December 4, 2020

This Microsoft update seems relevant: https://support.microsoft.com/en-us/help/4507704/dst-changes-in-windows-for-brazil-and-morocco

0 0

replied on December 7, 2020

Thanks Brian, i'll check it.

0 0

You are not allowed to follow up in this post.

Question

Question

Incorrect creation time of files

Replies

Sign in to reply to this post.