topic Re: Date interpretation in App Development

Date interpretation

mathieme — Sat, 16 Nov 2024 19:55:26 GMT

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

Re: Date interpretation

jerifortune — Thu, 10 Oct 2019 18:56:27 GMT

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))

)

Re: Date interpretation

JGMDataAnalysis — Fri, 11 Oct 2019 04:02:50 GMT

Read this...

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