Hi there, (I hope this is the correct subforum, not really sure where to post)
At the moment I have to change some reports from freehand SQL to universe based reports. Obviously they should bring the same result after the changes, but i noticed something strange:
The report is used to get mainly the number of transactions of the past month, so it uses (have to translate roughly here since im using german)
h.date >= @Variable('1. From dd.mm.yyyy')
and h.date <= @Variable('2. to dd.mm.yyyy')When putting this to universe, representing the same code as objects i have to replace the ‘<=’ part with ‘<’ to get the same result (I have difference of 2, which may or may not come from another source).
While testing I found that in Freehand ‘<=’ & ‘>=’ get the same results as ‘<’ & ‘>’ which, if I am not stupid, shouldn’t be (I checked if there are transactions on the 1./31. Jan)
Since I have to get the correct result, I am now unsure which method to use, to “translate” from FHSQL into universe objects.
Maybe someone can help me/clarify why there is a difference? (I didn’t find much online but might be, i don’t know the right terms to search for)
Thanks in advance
Shukaku (BOB member since 2017-01-11)