Dates displayed a day earlier in metadata editor

[PeteMB 13]

I have a problem with dates, they are displayed a day earlier when opening a movie or persons profile in the metadata editor. This happens with “Date added”, “LabelBirthDate”, “Death date” and “Release date”. The dates are also displayed a day earlier in clients that display Birthdates, like MBC with Square theme and wp8 app. Only in the webclient the birthdates are displayed correctly.

 

It doesn’t seems to be the same problem discussed here

I my case the dates are stored correctly in the movie.xml or person.xml files, but when I open the profiles in the metadata editor the dates are displayed a day earlier. If I save the profile now, the wrong dates are written to the xml files. So whenever I want to make a change in a profile I first have to change the dates back to a day later.

 

With the added date field the behavior is almost the same, only the first time I go into the profile the added date field is displayed correctly, when I do a change and save the profile, the next time I open the profile the added date field will be displayed as a day earlier. It seems originally the added date field is stored as date + time, when I make a change and save the profile the time is zeroed out  and stored as 0:00:00 and this makes a difference.

 

As an example, if I open the profile I the web client the birth date is displayed correctly

 

When I open the same profile on my windows phone the birthdate is displayed a day earlier

 

If I open this profile in the metadata editor, the birthdate is displayed a day earlier, the added date field is correct.

 

The birthday in the person.xml file.

 

If I save the profile and go back to Kevin Spacey's profile in the webclient the birthdate is changed to a day earlier

 

Now the wrong date is stored in the person.xml file, also the added date field time is now zeroed out.

If I now open the profile in the metadata editor, both date added and birthdate are displayed a day earlier.

 

 

 

For the moment I am running server version 3.0.5441.2

[PeteMB 13]

Trying to find the problem I have installed mediabrowser server on an other system, on windows 8.1 ent running as virtual machine. And I still have the same problems.

Mediabrowser version is the latest beta release 3.0.5445.6, I have attached the server logs.

 

As another example of the date problem here the movie.xml file of a movie (American Beauty)

The added date is 27/11/2014  16:04:58 and the premiere date 1999-09-15

 

 

When I open this profile in the metadata I get the following dates, added date 2014-11-27 (correct one) but a premiere date of 1999-09-14, this is a day earlier than in the xml file

 

When I make a change, like adding the correct parental rating for my country and save the profile the dates are also changed in the movie.xml file.

 

When I open the profile again in the metadata editor, both dates will be shown a day earlier.

 

 

I would be nice if somebody else could confirm they have the same problem.

server-63552977829.txt

[PeteMB 13]

I tried changing my Region and Language settings from Dutch (Belgium) to English (United States), it didn't solve the problem.

[ScottIsAFool 517]

@@Luke just been looking into this a little as it got reported on the Windows Phone forums. It looks like when requesting an item, the premieredate is an hour off so instead of being "PremiereDate": "1982-09-22T00:00:00.0000000Z" it's coming through as "PremiereDate": "1982-09-21T23:00:00.0000000Z" and so the clients (and metadata editor) are displaying the incorrect date. 

[PeteMB 13]

Thanks for looking into this problem. when this will be fixed it will be a big time saver for me.

[Luke 42079]

Please report back after the next server release. thanks.

[PeteMB 13]

Luke, I have done some more test with the dev version 3.0.5513.39888 and the problem seems to be half solved. At first I thought nothing was changed because the wrong dates were still displayed in the metadata editor. But the good thing is that these wrong dates are not written to the movie.xml files anymore. So I can edit profiles without the need to change the dates back to the correct ones. The only date displayed correctly are the added dates when they have a time higher than 0:59:59.

In all other places the dates are still displayed as a day early.

[ulrick65 30]

On 2/5/2015 at 2:23 PM, PeteMB said:

Luke, I have done some more test with the dev version 3.0.5513.39888 and the problem seems to be half solved. At first I thought nothing was changed because the wrong dates were still displayed in the metadata editor. But the good thing is that these wrong dates are not written to the movie.xml files anymore. So I can edit profiles without the need to change the dates back to the correct ones. The only date displayed correctly are the added dates when they have a time higher than 0:59:59.

In all other places the dates are still displayed as a day early.

I know this really (really) old, but the problem still persists. For example, actor birthdays are displayed one day prior to their actual date:

For example, Winona Ryder:

TMDB has her birthday as:  

"birthday": "1971-10-29",

Emby reports her birthday as:

Birthday: 10/28/1971 4:00:00 AM

While in Emby she shows up as:

 

I check many others and the same thing holds true.

@LukeCan you confirm if this was even worked on and fixed?

Thanks.

Edited October 21, 2024 by ulrick65

[Carlo 4561]

I'm not seeing this on my server.

What happens if you refresh the meta data for this person from the 3 dot menu?

[ulrick65 30]

6 hours ago, Carlo said:

I'm not seeing this on my server.

What happens if you refresh the meta data for this person from the 3 dot menu?

I have refreshed and rebuilt the entire library, it didn't change. 

I wonder if it has to do with timezone issues.  What timezone are you inm

[Happy2Play 9780]

11 hours ago, ulrick65 said:

Emby reports her birthday as:

Birthday: 10/28/1971 4:00:00 AM

Where are you seeing this as I see no where that provides zulu time?

But can say I see what TMDB/TVDB provider provides.

person.nfo

But can guess anything using zulu info could potentially not localize correctly as that was a issue in that past.

[Carlo 4561]

Assuming the date is entered correctly as a person born in California on 1/31 at 9pm would be 2/1 zulu, but we have no control over that.

@ulrick65Do you notice any other date issues from this provider, such as release dates being off as well?

[ulrick65 30]

Sorry folks... a false alarm. These is remnants of a project...these did NOT come from TMDB as I thought.  I have sorted it out...all good.

Thanks for the quick responses.

"You will now be returned to your regularly scheduled program...already in progress."

 

[ulrick65 30]

Short update:

I am getting "4:00 am" returned from the API.  What that tells me is that Emby is storing the value as UTC, so midnight here (EST) is 4am UTC. It is daylight savings here in NY, and 4 hours behind Zulu or UTC or UCT or CUT or GMT or whatever you prefer to call it. However, the root of my original problem was not related to this...it is just an observation. Reality is it probably should not provide the time at all and just the date, but doesn't affect me here...but might some people.

 

Edited October 21, 2024 by ulrick65

[Happy2Play 9780]

23 minutes ago, ulrick65 said:

Short update:

I am getting "4:00 am" returned from the API.  What that tells me is that Emby is storing the value as UTC, so midnight here (EST) is 4am UTC. It is daylight savings here in NY, and 4 hours behind Zulu or UTC or UCT or CUT or GMT or whatever you prefer to call it. However, the root of my original problem was not related to this...it is just an observation. Reality is it probably should not provide the time at all and just the date, but doesn't affect me here...but might some people.

 

Yep as the timestamp is recorded in the database so yes timezones can be a factor.  But yes things like this have come up before as technically one's birth date would be different around the world but really is not views that way and should be that specific date.

{
  "Name": "Winona Ryder",
  "ServerId": "29fd5b1915774xxxxxxxxxxxxxxxx",
  "Id": "10936",
  "Etag": "8c49998c4f9899f6222fe839e5e0e83b",
  "DateCreated": "2024-02-18T21:01:28.0000000Z",
  "CanDelete": false,
  "CanDownload": false,
  "PresentationUniqueKey": "a0f2186a60b645be852b1bf7b20771c1",
  "SortName": "Winona Ryder",
  "ForcedSortName": "Winona Ryder",
  "PremiereDate": "1971-10-29T07:00:00.0000000Z",
  "ExternalUrls": [
    {
      "Name": "IMDb",
      "Url": "https://www.imdb.com/name/nm0000213"
    },
    {
      "Name": "MovieDb",
      "Url": "https://www.themoviedb.org/person/1920"
    },
    {
      "Name": "TheTVDB",
      "Url": "https://thetvdb.com/people/321116"
    }
  ],
  "ProductionLocations": [
    "Winona, Minnesota, USA"
  ],
  "Overview": "Winona Laura Horowitz (born October 29, 1971), known professionally as Winona Ryder, is an American actress. She is the recipient of several awards, including a Golden Globe Award, and has been nominated for two Academy Awards. She is known for taking on quirky roles in her earlier films, later playing more prominent roles in the 1990s.\n\nAfter Ryder's film debut in Lucas (1986), she gained attention with her performance in Tim Burton's Beetlejuice (1988). She further rose to prominence with major roles in Heathers (1989), Mermaids (1990), Edward Scissorhands (1990), and Bram Stoker's Dracula (1992). She garnered critical acclaim and two consecutive Academy Award nominations for her portrayals of socialite May Welland in Martin Scorsese's The Age of Innocence (1993) and Jo March in the fifth film adaptation of Little Women (1994). Her other films during this period were Reality Bites (1994), How to Make an American Quilt (1995), The Crucible (1996), Alien Resurrection (1997), Celebrity (1998), and Girl, Interrupted (1999), which she also executive-produced.\n\nIn 2002, Ryder starred in the critically panned box office hit Mr. Deeds, after which her career declined and she took a break from films. In 2009, she returned in the high-profile film Star Trek. In 2010, she was nominated for two Screen Actors Guild Awards: as the lead actress in the television film When Love Is Not Enough: The Lois Wilson Story and as part of the cast of Black Swan. She also reunited with Burton for Frankenweenie (2012). She has starred as Joyce Byers in the Netflix science fiction horror series Stranger Things (2016–present), for which she has received Golden Globe and Screen Actors Guild nominations; and in 2020, she starred in the HBO drama miniseries The Plot Against America.\n\nHer relationship with Johnny Depp in the early 1990s and a 2001 arrest for shoplifting were both subjects of tabloid journalism. She has been open about her personal struggles with anxiety and depression. In 2000, Ryder received a star on the Hollywood Walk of Fame.",
  "Taglines": [],
  "ProductionYear": 1971,
  "RemoteTrailers": [],
  "ProviderIds": {
    "tmdb": "1920",
    "tvdb": "321116",
    "Imdb": "nm0000213"
  },
  "Type": "Person",
  "DisplayPreferencesId": "b607178b0ac2f604a458d3d2363fdc83",
  "PrimaryImageAspectRatio": 0.6666666666666666,
  "ImageTags": {
    "Primary": "abd669b96455a921e3270fb99b2edef3"
  },
  "BackdropImageTags": [],
  "LockedFields": [],
  "LockData": false
}