How can i use a date field with where condition with in the qlikview script,
i made some thing like.
where aq= 'aaa' and Date=to_date('03.04.2014','DD.MM.YYYY');
But there is a syntax error for the date part.
Where have you found the to_date function?
I would write
where aq= 'aaa' and Date=Date('03.04.2014','DD.MM.YYYY');
Retrieving data ...