using the date field with where condition

[marksmunich]

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 · Accepted solution]

Where have you found the to_date function?

I would write

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

[marksmunich]

problem solved.