Menu
Free Trials

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

Public
Dmytro Zvazhii Flexmonster October 28, 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/

Regards,
 Dmytro

Please login or Register to Submit Answer