Print

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

[c1c9k72]

I've been struggling with this for a while, and it's probably very simple.  When I have a TV show, I like to encode the date of first airing into the filename.  It used to work very simply with the following expression: [Album]-[Track #]-[Date (Year)]-[Date (Month)]-[Date (Day)]-[Name].

What I would end up with is something like: House MD-101-2004-12-16-Pilot.avi
However, lately, I've been ending up with: House MD-101-2004-December-16-Pilot.avi

MC11 handles months fine, but other software doesn't.  I'd like to return to the old method of doing it with just numbers, but I can't figure out how to make the formatdate system work.  Where would I enter the formatdate expression ?  And how exactly would I code it to do what I'd like to do ?

[Matt]

Fields get formatted by default with MC 11.1.

Switch:
[Date (Month)] to [Date (Month), 0]

Also, you could use this as a shortcut:
FormatDate([Date, 0], yyyy-MM-dd)

More details:
http://www.jrmediacenter.com/DevZone/DBExpressions.htm

[c1c9k72]

Thanks for the help, Matt, but when I enter this:

[Album]-[Track #]-[Date (Year)]-[Date (Month) ,0]-[Date (Day)]-[Name]

It tells me that [Date (Month), 0] is an invalid keyword, and requests I correct it.

[Matt]

You found a bug.  Rename supports expressions, but the syntax checker was too aggressive.

It'll be fixed next build.

[c1c9k72]

I just downloaded 11.1.126 and tested the "rename file from properties" modifications.  I fed it [Album]-[Track #]-[Date (Year)]-[Date (Month), 0]-[Date (Day)]-[Name] and it still leaves the month in word form.

While I've got you on the subject of formatting, I do have one other question.  I'd like to ensure that my track numbers are a specific length, like 2 digits or 3.  Is that possible ?

[Matt]

Use this instead of that string of calculated fields:
FormatDate([Date, 0], yyyy-MM-DD)

I think track number will autmatically use two digits when you do a rename.

[c1c9k72]

That last formula fixed the date problem completely.  Thanks a lot, Matt.

[marko]

You found a bug.  Rename supports expressions, but the syntax checker was too aggressive.

It'll be fixed next build.

Neville found it a few days ago...

if it is a bug, the team will see this and most probably fix it. if nothing else, the above method will save you waiting.
regards,
-marko.

thanks for the fix.

[Neville]

Thank you for fixing this