INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: Odd Date Behavior  (Read 1149 times)

steveklein

  • Galactic Citizen
  • ****
  • Posts: 478
Odd Date Behavior
« on: August 25, 2009, 03:54:49 am »

I'm trying to get the Date field updated from my filename in my movie collection.

My movies are on disk at E:/Movies/Name of Movie - Year/Name of Movie.avi

When I go to the fill properties from filename, I have the directories box checked and it has the contents [Name] - [Date]. I have the filename box unchecked, as it should derive it from the directory.

The odd behavior is that instead of putting the year, it puts a date in 1905. I'm not sure, but I believe it is however many days into the century of 1900. For instance, the little mermaid's date shows up as 6/11/1905 (the 1989th day starting with 1900?) while the lion king shows up as 6/16/1905 (the 1994th day of the year?)

any ideas? is my logic wrong, or is this a bug?
Logged

gappie

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 4566
Re: Odd Date Behavior
« Reply #1 on: August 25, 2009, 05:06:57 am »

it has something to do with how date in mc, something like minutes since 1970, or something like that. there are some very old threads about it.
what seems to work is [name] - [year].
it will keep the months and days when they are there already. so maybe you have to clean the date first for those who have a day and month in date.

 :)
gab
Logged

Alex B

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 10121
  • The Cosmic Bird
Re: Odd Date Behavior
« Reply #2 on: August 25, 2009, 05:07:08 am »

The odd behavior is that instead of putting the year, it puts a date in 1905. I'm not sure, but I believe it is however many days into the century of 1900. For instance, the little mermaid's date shows up as 6/11/1905 (the 1989th day starting with 1900?) while the lion king shows up as 6/16/1905 (the 1994th day of the year?)

That is aproximately the internally used date & time system. The visible value in the user interface is calculated from the internal value. More info: http://yabb.jriver.com/interact/index.php?topic=43983.msg301174#msg301174

You can use

[Name] - [Date (year)]

or

[Name] - [Year]   (MC can parse the [Year], [Month] and [Day] strings in rules and import the data to the Date field, which can store precise time stamp values.)

and get the desired result.


EDIT

... and as gappie said, you may need to clear the values first if they already contain more precision than the plain year value.
Logged
The Cosmic Bird - a triple merger of galaxies: http://eso.org/public/news/eso0755

Alex B

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 10121
  • The Cosmic Bird
Re: Odd Date Behavior
« Reply #3 on: August 25, 2009, 05:10:34 am »

gappie,

the Unix epoch based "1970..." system is used internally only for storing the Date Created, Date Imported and Date Modified values.
http://yabb.jriver.com/interact/index.php?topic=43983.msg301174#msg301174

EDIT

...and
http://yabb.jriver.com/interact/index.php?topic=37245
http://yabb.jriver.com/interact/index.php?topic=50750
http://yabb.jriver.com/interact/index.php?topic=40963

EDIT 2

The Date field starts counting from December 31, 1899, 00:00 AM. (= 1)

Actually, by MS's defination the earliest valid date is January 1, 100 A.D. (= -657434), but I don't know if it would work in MC. For example, here's a quote from: http://techrepublic.com.com/5208-7343-0.html?forumID=101&threadID=273373&messageID=2590399
Quote
Access stores the Date/Time data type as a double-precision, floating-point number up to 15 decimal places. The integer part of the double-precision number represents the date. The decimal portion represents the time.

Valid date values range from -657,434 (January 1, 100 A.D.) to 2,958,465 (December 31, 9999 A.D.). A date value of 0 represents December 30, 1899. Access stores dates before December 30, 1899 as negative numbers.

Valid time values range from .0 (00:00:00) to .99999 (23:59:59). The numeric value represents a fraction of one day.
Logged
The Cosmic Bird - a triple merger of galaxies: http://eso.org/public/news/eso0755

gappie

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 4566
Re: Odd Date Behavior
« Reply #4 on: August 25, 2009, 05:24:04 am »

thanks alex,
so it is not used for the date? i tested the [name] - [date] with Soylent Green - 1973,
when i use fill properties from filename i gives 26-5-1905 as date, when i make an expression collumn using [date,0] it tells me 1973. i wonder what system i used here then?

thanks for the links, i read them in the past, its interesting again.

 :)
gab

edit, your post got edited while i was typing.. thanks for explaining that one also... ;D
Logged
Pages: [1]   Go Up