Print

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

[rhom]

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?

[John Gateley]

Use:

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

j

[Neville]

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.

[marko]

hi Neville, did you try:

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

?

[Neville]

No, it gives me this error:

[marko]

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...



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...



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.

[Neville]

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