Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
marksmunich
Contributor II

using the date field with where condition

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.

Tags (2)
1 Solution

Accepted Solutions

Re: using the date field with where condition

Where have you found the to_date function?

I would write

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

2 Replies

Re: using the date field with where condition

Where have you found the to_date function?

I would write

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

marksmunich
Contributor II

Re: using the date field with where condition

problem solved.

Community Browser