INTERACT FORUM

More => Old Versions => Media Center 11 (Development Ended) => Topic started by: rhom on January 31, 2006, 01:35:25 am

Title: Rhom: FormatDate question
Post by: rhom on January 31, 2006, 01:35:25 am

i have the following advanced expression in one of my view schemes

FormatDate([Date Imported], yyyy-MM-dd,0000-00-00)

in 11.0.318 it worked fine, yesterday i installed 11.1.108 and it doesn't work anymore, today i tried 11.1.109 and it's still wrong.

i've reimported all my songs yesterday (30/01/2006) and it's displaying 1900-01-29 instead of 2006-01-30

has the date format strings been changed in 11.1 or do they no longer work?

Title: Re: Rhom: FormatDate question
Post by: John Gateley on January 31, 2006, 10:50:17 am

Use:

FormatDate([Date Imported,0], yyyy-MM-dd,0000-00-00)

j

Title: Re: Rhom: FormatDate question
Post by: Neville on February 18, 2006, 04:04:35 pm

I have the same problem with latest version 11.1.123

I'm using this expression: FormatDate([Date], yyyy-MM-dd) and it gives me something like 1900-01-10 instead of 2006-02-16 in Rename files from properties dialog.
This expression FormatDate([Date], yyyy-MM-dd,0000-00-00) doesn't work either.
Please help, it worked before in 11.0 version.

Title: Re: Rhom: FormatDate question
Post by: marko on February 18, 2006, 04:47:10 pm

hi Neville, did you try:

FormatDate([Date,0], yyyy-MM-dd

?

Title: Re: Rhom: FormatDate question
Post by: Neville on February 20, 2006, 01:15:55 am

No, it gives me this error:

(http://img114.imageshack.us/img114/2852/screenshot0013qd.png) (http://imageshack.us)

Title: Re: Rhom: FormatDate question
Post by: marko on February 20, 2006, 02:04:24 am

formatdate([date,0],yyyy-MM-dd)

does work, but not when used in the rename from properties tool. I'm not sure if this is a bug or not, but assuming that it is not, a work around for you is to create an expression based library field, like so...

(http://www.theganghut.co.uk/pics/ia/formatdate.jpg)

Use what you like for name, display, category and keywords, but make sure the "data" info is as shown, with the above expression placed in there. Then your rename template would look like so...

(http://www.theganghut.co.uk/pics/ia/formatdate2.jpg)

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.

Title: Re: Rhom: FormatDate question
Post by: Neville on February 20, 2006, 02:10:44 am

Thanks so much for help! This is one excellent tip.