Hi....am trying to build a query in the AS400, we are currently using, V05R03M00 IBM AS400. In my query, I have two fields: DATECOLL 'yyyy-mm-dd' and TIMECOLL 'hh:mm:ss'.
I need all tests that were collected 24 hours ago from the date/time the query is run. I've tried everything I can think...