INTERACT FORUM

Please login or register.

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

Author Topic: Tag differences  (Read 1408 times)

dcwebman

  • Citizen of the Universe
  • *****
  • Posts: 2154
Tag differences
« on: August 21, 2006, 07:36:58 am »

There are some differences in the Tag fields available in MC 12 vs. 11.

In the tag info, I can't seem to find the Last Played field. I can see how many days ago it played but then I'd have to pull out a program to calculate what date that was.

While in the Tag info, it has been mentioned that the BPM field isn't there but the Intensity field isn't either. Both BPM and Intensity can be edited in MC 11.

In the detailed Format info, it displays COMM (Date) as a number like 28126. This doesn't appear to be a Julian date. What is it?
Logged
Jeff

Alex B

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 10121
  • The Cosmic Bird
Re: Tag differences
« Reply #1 on: August 21, 2006, 03:24:28 pm »

It is a serial date number since January 1st, 1900. Excel uses the same system.

"Year" has a separate field in file tags. Usually the COMM (date) tag in audio files is just the first day of the year unless you have really tagged a certain date.


Inside the database MC uses this system for calculating time:

Q:
I'm looking for a way to build a smartlist that shows the [last played] before a certain date.

So eg. show me all songs last played before 2005/01/18

I tried the following expression:

FormatDate([Last Played,0],yyyyMMdd)&DataType=[Number] <= 20050118

but this shows me no results

Anyone could help ?

A:
It seems that MC's calendar starts from January 1st 1970, 2:00 am. Internally MC counts seconds so the search expression would be:
[Last Played]=<1105999200

Easy as pie, isn't it.  :)

(I don't know if MC accepts any other time format. If it doesn't, a usable date format should be added.)

How about changing this in MC12?
Logged
The Cosmic Bird - a triple merger of galaxies: http://eso.org/public/news/eso0755
Pages: [1]   Go Up