INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: Group by Date Imported shows Unix time  (Read 868 times)

jcouch93

  • Regular Member
  • World Citizen
  • ***
  • Posts: 138
  • I'm confused...
Group by Date Imported shows Unix time
« 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?  

Logged

jcouch93

  • Regular Member
  • World Citizen
  • ***
  • Posts: 138
  • I'm confused...
Re: Group by Date Imported shows Unix time
« Reply #1 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.
Logged

marko

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 8967
Re: Group by Date Imported shows Unix time
« Reply #2 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
Pages: [1]   Go Up