Print

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

[jcouch93]

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?  

[jcouch93]

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.

[marko]

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