13 votes

Date formatting rule (e.g. trim the date field to just the year)

Bruce 10 supporters

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

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

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

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

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

Very true, but then it's a similar situation elsewhere - depending on your player different fields can be interpreted in different ways.