I have an AFTable where I do table lookups into my attribute 'Sum_Abonnemang', configured like this:
SELECT Sum(Abonnemang) FROM [AboTabell] WHERE Station = '%Element%' AND [Start time] <= #%Time%# AND [End time] > #%Time%#
Aditionally I have an expression analysis time scheduled at midnight, and configured like:
If I evaluate this I get the current value of the 'Sum_Abonnemang' tag, but I don't get any results if I 'preview' the results. But it works if I manually change the MyTime variable to ParseTime("t-1d") or "t-5d". What am I doing wrong?
I'm on the latest and greatest version-wise here.