topic Re: Expression issue in QlikView https://community.qlik.com/t5/QlikView/Expression-issue/m-p/718224#M1082583 <HTML><HEAD></HEAD><BODY><P>Hi. Kindly put dateAdd() to a variable and pass that variable to the query. Regards, Jitendra</P></BODY></HTML> Fri, 20 Jun 2014 11:21:53 GMT 2014-06-20T11:21:53Z Expression issue https://community.qlik.com/t5/QlikView/Expression-issue/m-p/718223#M1082582 <HTML><HEAD></HEAD><BODY><P>Hi, I have a problem with filter my dates from database.</P><P>This is a format of date from db : "YYYYMMDDhhmmCEST" and I want to download values between for ex. 01.01.2014 AND ...</P><P>and here is my problem - i want to pass today date - 20 minutes, I tried to use : </P><P>TIME_KEY BETWEEN '20140101' AND 'DateAdd(mi, -20, getDate())' </P><P>but it looks like the DateAdd part is just ignored <IMG src="https://community.qlik.com/legacyfs/online/emoticons/cry.png" /></P><P>Any other function to work this out ?</P></BODY></HTML> Fri, 20 Jun 2014 10:58:51 GMT https://community.qlik.com/t5/QlikView/Expression-issue/m-p/718223#M1082582 2014-06-20T10:58:51Z Re: Expression issue https://community.qlik.com/t5/QlikView/Expression-issue/m-p/718224#M1082583 <HTML><HEAD></HEAD><BODY><P>Hi. Kindly put dateAdd() to a variable and pass that variable to the query. Regards, Jitendra</P></BODY></HTML> Fri, 20 Jun 2014 11:21:53 GMT https://community.qlik.com/t5/QlikView/Expression-issue/m-p/718224#M1082583 2014-06-20T11:21:53Z