Topic: [23.0.100x64; Change Request] Using first file's date as sorting date (Read 1617 times)

Gatherum · « **on:** February 11, 2018, 08:28:15 pm »

So I have a custom library field: [Date (compilation exception)], with calculated data:

If(IsEqual([Release Type,0],Compilation),FormatDate([Date (release),0],yyyy-MM-dd),FormatDate([Date,0],yyyy-MM-dd))One can sort by this field in order to have a chronological listing of albums, but it considers the [Date (release)] field for compilations instead of the regular [Date] field because compilations often contain tracks of varying original release dates.

Lately, however, I've been moving away from this method in sorting because it is common for certain (re-release) editions of albums have extra tracks with different original release dates, and I don't favour re-labelling all of these as compilations.

Is there a way to re-write the code for the custom field above so that it simply sorts a whole album by the [Date] of the first file there-in? As it stands, with varying dates across all tracks, MC is calculating an "average" value out of all tracks, which is leading to some...odd and unexpected results (see attachment).

Gatherum · « **Reply #1 on:** February 12, 2018, 03:19:22 am »

Anybody?
I've tried this:

Code: [Select]

FormatBoolean(IsEqual([Track #],1,2),[Date])It doesn't work.

Matt · « **Reply #2 on:** February 12, 2018, 11:21:55 am »

I think it's going to average if there's a group of tracks. Not sure any way around that.

Gatherum · « **Reply #3 on:** February 12, 2018, 12:28:33 pm »

Aww.

Gatherum · « **Reply #4 on:** February 16, 2018, 12:12:05 am »

Would it be possible to change things so that multi-date albums are handled as suggested in the OP?

I'm not really seeing a particular benefit to outputting an average date.

Gatherum · « **Reply #5 on:** February 18, 2018, 03:04:36 pm »

Or would making this change be more complex than I'm making it sound?

ferday · « **Reply #6 on:** February 18, 2018, 08:24:23 pm »

I use an expression that compares date and date release - if they are equal then display date otherwise display date release

This should work for you?

INTERACT FORUM

Author Topic: [23.0.100x64; Change Request] Using first file's date as sorting date (Read 1617 times)

Gatherum

[23.0.100x64; Change Request] Using first file's date as sorting date

Gatherum

Re: [23.0.100; Query] Using first file's date as sorting date

Matt

Re: [23.0.100; Query] Using first file's date as sorting date

Gatherum

Re: [23.0.100; Query] Using first file's date as sorting date

Gatherum

Re: [23.0.100x64; Change Request] Using first file's date as sorting date

Gatherum

Re: [23.0.100x64; Change Request] Using first file's date as sorting date

ferday

Re: [23.0.100x64; Change Request] Using first file's date as sorting date