topic Re: using the date field with where condition in QlikView

using the date field with where condition

marksmunich — Thu, 06 Mar 2014 08:42:29 GMT

How can i use a date field with where condition with in the qlikview script,

i made some thing like.

Load

aq,

ads,

asda,

adsaasd,

Date

from asdf.qvd(qvd)

where aq= 'aaa' and Date=to_date('03.04.2014','DD.MM.YYYY');

But there is a syntax error for the date part.

alexandros17 — Thu, 06 Mar 2014 08:51:35 GMT

Where have you found the to_date function?

I would write

where aq= 'aaa' and Date=Date('03.04.2014','DD.MM.YYYY');

marksmunich — Thu, 06 Mar 2014 09:01:48 GMT

problem solved.