Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
Hi. Kindly put dateAdd() to a variable and pass that variable to the query. Regards, Jitendra
Hi. Kindly put dateAdd() to a variable and pass that variable to the query. Regards, Jitendra