Expression issue

[#1]

Hi, I have a problem with filter my dates from database.

This is a format of date from db : "YYYYMMDDhhmmCEST" and I want to download values between for ex. 01.01.2014 AND ...

and here is my problem - i want to pass today date - 20 minutes, I tried to use :

TIME_KEY BETWEEN '20140101' AND 'DateAdd(mi, -20, getDate())'

but it looks like the DateAdd part is just ignored

Any other function to work this out ?

[#2 · Accepted solution]

Hi. Kindly put dateAdd() to a variable and pass that variable to the query. Regards, Jitendra