Thank you all very much for your help. It turned out that the field uses timezone information, which is why a simple date comparison didn’t work. I used the DATETIME-TZ function and it works perfectly!
I’m not the database administrator – the entire solution is on the ERP system vendor’s side...
We’re using an ERP system built on Progress OpenEdge (Release 11.6.3.023). I need to extract audit log data for a specific table — in particular, I’m interested in a specific event that occurred between two given dates. I’ve been trying various approaches, but I can’t seem to get date filtering...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.