INTERACT FORUM

More => Old Versions => Media Center 11 (Development Ended) => Topic started by: drosoph on August 01, 2006, 10:19:56 am

Title: Calculated MONTH field?
Post by: drosoph on August 01, 2006, 10:19:56 am

I need to pull out the MONTH from my file format YYYYMMDD - Name.divx

The DIVX files, when imported, have all fields showing the IMPORTED date as the date for the file.  How do I get this Year and Month (Alpha, not numeral) into some fields so I can use it to create directories later?

Title: Re: Calculated MONTH field?
Post by: marko on August 01, 2006, 11:06:10 am

Quote from: drosoph on August 01, 2006, 10:19:56 am

I need to pull out the MONTH from my file format YYYYMMDD - Name.divx

Create a new library field, it will be a calculated field, and the template will be:

mid([filename (name)],4,2)

Quote from: drosoph on August 01, 2006, 10:19:56 am

The DIVX files, when imported, have all fields showing the IMPORTED date as the date for the file.  How do I get this Year and Month (Alpha, not numeral) into some fields so I can use it to create directories later?

similarly, this will get you the month: formatdate([date,0],month)
and this the year: formatdate([date,0],yyyy)