From searching the forum it appears people have been asking this question for years with no simple solution. While it appears to be clunky maybe something like this would work. The problem is if you have a large record set with only a few dates you skip a lot of records doing nothing.
domain tfgld.date h.date
select CAST(tdsls400.odat AS DATE):h.date
if changed(h.date) then
|Got a new date so do something with it.
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.
systems provided free by Baan Board
Play the Google game and help Baanboard get better rankings. Do your part. Click here
to find how.