13
votes
Date formatting rule (e.g. trim the date field to just the year)
It would be helpful if you could force the date field to be just the year - as in, 1997/02/28 to simply 1997
It would be helpful if you could force the date field to be just the year - as in, 1997/02/28 to simply 1997
5 comments
Dan Gravell 23 May 2017
Also, more generally, support for formatting date/time fields. So you could specify:
YYYY
As your format, so only years are stored. Or:
MM/DD/YYYY
For a full date in the common US format.
Not sure how the date should be filled when there isn't enough information... maybe simply omitting the more specific parts would be fine.
Trevox 27 May 2017
ISO date welcome (YYYY-MM-DD). EU and US dates can be ambiguous for MM and DD if > 13. YYYY would be OK if rest of tag ambiguous or undefined.
Dan Gravell 29 May 2017
Yeah, that's a concern when changing existing fields, but if we combine that with online data, where the date is formatted in a consistent way, we can work around that.
Mike Lerch 1 Jun 2017
I too would appreciate this feature, and have a preference to be able to specify the ISO date format. For releases where Bliss can't find the info and where I didn't know it I would just use January first of a given year.
That said, will different players interpret the values in this field differently? E.g. if some users wish to format as YYYY and others format as DD/MM/YYYY, how will different software interpret those very different strings?
Dan Gravell 1 Jun 2017
Very true, but then it's a similar situation elsewhere - depending on your player different fields can be interpreted in different ways.