INTERACT FORUM

More => Old Versions => JRiver Media Center 20 for Windows => Topic started by: jcouch93 on October 10, 2014, 04:58:55 pm

Title: Group by Date Imported shows Unix time
Post by: jcouch93 on October 10, 2014, 04:58:55 pm

I created a new Library View for my imported files and noticed that if I group them they are grouped by the Unix date (i.e. the group headers show 1410827370 instead of the date).  Can this be resolved or is grouping just not going to work?  

(http://i573.photobucket.com/albums/ss177/jcouch93/Internet%20Pictures/MC20-GroupUnixTime.jpg)

Title: Re: Group by Date Imported shows Unix time
Post by: jcouch93 on October 13, 2014, 09:21:24 pm

Can anyone confirm they see the same thing and if so is it a bug?  I would think so since those groups aren't human readable.

Title: Re: Group by Date Imported shows Unix time
Post by: marko on October 14, 2014, 01:07:51 am

I see the same. It's grouping by the raw 'import date' data.

The work around here is to create a new, expression based library field using the expression: formatdate([date imported,0],date)

and then group by that new field.

Now, here in the UK, we use dd/mm/yyyy, which does not sort properly, so I set a field using: formatdate([date imported,0],yyyy/MM/dd) which is better for sorting purposes.

-marko