Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Where have you found the to_date function?
I would write
where aq= 'aaa' and Date=Date('03.04.2014','DD.MM.YYYY');
Where have you found the to_date function?
I would write
where aq= 'aaa' and Date=Date('03.04.2014','DD.MM.YYYY');
problem solved.