Date interpretation

[mathieme]

Hi,

I'm having trouble with values in a non-date field wrongfully being interpreted as dates when loaded into Qlik. The problem is easily solved by using the text() function but, nevertheless, is has raised the question why a given value is interpreted as a date or not since it seems to occur randomly in my data set. In addition, in some cases Qlik converts the values from date format to its numeric representation, and in other cases it's the other way around. See example below:

1st row: Value is converted from "date" format to numeric representation
2nd row: Value is converted from numeric representation to date format.
3rd and 4th row: no convertion is made. 

It is the inconsistency that bothers me.

Thank you,

Marcus

[jerifortune]

Try this

IF (FindOneOf([Data Source Date],'-') <> 0, Date([Data Source Date]),

Date(Left( [Data Source Date], Index([Data Source Date],'-') -1 ) & '-'& MID([Data Source Date],Index([Data Source Date],'-',-1)-2,2) &'-'&MID([Data Source Date],Index([Data Source Date],'-',-1)+1))

)

[JGMDataAnalysis]

Read this...

https://community.qlik.com/t5/QlikView-Documents/QlikView-Date-fields/ta-p/1484786?attachment-id=120...