Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[drosoph]

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?

[marko]

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)

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)