topic Re: Date value in inline statement in QlikView

Date value in inline statement

Wed, 13 Jul 2011 18:24:54 GMT

I don't know how to pass a date value in inline statement like:

T1:

LOAD * INLINE [

Col1, Col2

124, '30/12/1996'

];

QlikView treats this column as string and not date-time data type. Can you please help?

Thanks in advance

Re: Date value in inline statement

Wed, 13 Jul 2011 18:33:41 GMT

Try this

SET DateFormat='DD/MM/YYYY';

T1:

LOAD Col1 , Date(Col2) as Date , Month( Col2) as Month

INLINE [

Col1, Col2

124, '30/12/1996'

];

Re: Date value in inline statement

nagaiank — Wed, 13 Jul 2011 20:52:05 GMT

Try the following with no single quotes for the date value:

T1:

LOAD * INLINE [

Col1, Col2

124, 30/12/1996

];

Re: Date value in inline statement

Anonymous — Thu, 29 Dec 2016 12:36:09 GMT

Thanks!! Did not use inline date before, I am doing a test, but the date can not be recognized when I am using format "MM/DD/YYYY", search most topic about this issue, surprisingly, only yours make the point, that is because the default DateFormat. And yes, it works without quote. Thanks very much.

Zhihong