Hi!
I am trying to get data that lie between two dates into a smart data browser, but I don't seem to get the queryprepare right.
variable a could be > OR < OR = etc
variable b could be > OR < etc
var c = 2001/02/02
var d = 2001/02/15
DYNAMIC-FUNCTION('Preparequery', 'for each table_a
where table_a.nr = "' + string(a_variable) + '" and table_a.date ' + a + ' "' + c + '" and table_a.date ' + b + ' "' + d + '", EACH.......').
Basically this:
for each table_a where table_a.nr = 1 (value comes from a variable) and table_a.date > (value comes from var) 2001/02/01(year/month/day)(value comes from var) and table_a.date < (value comes from var) 2001/02/20 (year/month/day)(value comes from var).
Is there anyone who could help me? I'm pretty sure the problem has to do with the dates.
Thanks!
/Hannele