Why a text type field is shown as Date type field if the value contains text like "…founded in September 2013"?

We have a field in which there is some descriptive value which contains Founded date as September 2013 as a part of text value. When I create a data view, this field is considered as Date type and it shows – Month, Year, Day options under it. Why is it so?

Attachments: sample (1).csv

1 answer

Dmytro Zvazhii Staff September 21, 2016

Hi Deepali,
Yes, it’s the known issue and it happens only in Chrome. You can try your data in FF or IE. The source of the problem is Chrome’s algorithm of dates recognition. If it finds a date in any part of the string, it treats the whole string as a date.
To resolve this issue please use “+” prefix. e.g.
Country, +Year, Sales
US, 2010, 200
UK, 2010, 100
Please find more information here: http://www.flexmonster.com/doc/data-types-in-csv/

Please login or Register to Submit Answer