Hi,
Using an asset listing we are grouping assets by a metadata date value.
The issue we are having is that we can not get the group sort to work correctly. We would like to display the presentation value rather than the raw value. If we do this however the sorting of dates is not behaving how we would like it to e.g. 03 December appears above 01 November but below 08 November.
Is there a way to group by a metadata date value, sort by raw value but show the presentation value?
When you are grouping by metadata date field, and using the raw value, I am pretty sure that it is using the time stamp which is more than just the date, it includes time too. So, because you are grouping by the raw value, and no two assets are probably created at the same second, you are going to get results that look like they are grouping each asset by itself, this is because none of the assets have the same raw metadata date value.
For sorting asset within the groups you can sort by raw metadata date value to make sure they are in order by their date field.
Actually no, the group by raw metadata value works fine and is grouping the assets as I want. However it's the display of the group heading that I want to change to the presentation value. I can not see any obvious options to change the settings so I'm guessing that it's not possible.
In case anyone's interested we got around this issue by using a text metadata value instead.
We formatted the entry <span class="hide">2008-01-01</span>1 January 2008
It's a bit annoying for the user entering the data but it achieves what we were after. The date is sorted correctly, the span is hidden and we can format the group heading however we like.