View Issue Details

IDProjectCategoryView StatusLast Update
0014601MMW v4Framework: Taggingpublic2018-01-26 01:28
Reporterpeke Assigned To 
PriorityurgentSeveritytweakReproducibilityalways
Status closedResolutionfixed 
Target Version4.1.20Fixed in Version4.1.20 
Summary0014601: Date detection issues
DescriptionCurrently Date/Year detection have limited functionality and can add incorrect data.

http://www.mediamonkey.com/wiki/index.php/WebHelp:Configuring_Directory_and_File_Formats/4.0

Adding Date format as Parameter or introducing new date function should ratify the problem.

Solution should be either:
a) <Date:YY-MM-DD> Where MMW will try to recognize date and time according to format
b) <DateEX:YY-MM-DD,70> Where MMW will try to recognize date and time according to format and second (eg. 70) will be number of years in the past that will be considered last century.

2 -> 4 year digit conversion explained in detailshttp://www.filemaker.com/help/12/fmp/html/add_view_data.4.21.html
Additional InformationRNU-925-25541
http://www.mediamonkey.com/forum/viewtopic.php?f=1&t=88963
TagsNo tags attached.
Fixed in build1862

Relationships

related to 0014626 assignedLudek MMW 5 Date Mask: Improve Date and Two Digit Year detection 

Activities

Ludek

2018-01-02 18:58

developer   ~0049472

Reading the ticket the user is objecting that:

1) MM hiccups on dates where both MM and DD are less than 13 (like 44-01-03), converting the date to Mar 1, 2044 instead of Jan 3, 44. Other dates that aren't "ambiguous" (44-05-15 for example) work fine.

2) Since in the US, the standard date format is mm-dd-yy (01/03/44) , and I'm using the alternate standard yy-mm-dd (44-01-03) -- the 01 in both systems would be the month. I have never heard of a system anywhere that uses yy-dd-mm - this format seems ludicrous. Europe uses dd-mm-yy, which will confuse us in the US, but with year first, even they use yy-mm-dd.

I agree that using 'yy-dd-mm' looks like a bug, i.e. eliminating this buggy format would probably solve most of the issues.

peke

2018-01-02 19:40

developer   ~0049473

I agree on both, I guess that quick fix if First two are >31 we always use yy-mm-dd ?

- Date format recognition and Epoch years calc can be added in future, MM5?

Ludek

2018-01-02 20:27

developer   ~0049474

Last edited: 2018-01-02 20:29

Yes, fixed in 1862.

peke

2018-01-03 22:25

developer   ~0049481

Verified 1862

Closing after adding new date features for MM5

peke

2018-01-26 01:24

developer   ~0049566

Closing for MM5 this will be handled thru 0014626