View Single Post
Old 20th December 2016, 02:09
mark_h's Avatar
mark_h mark_h is offline
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,114
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
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.
 select CAST(tdsls400.odat AS DATE)
 from tdsls400 
   if changed( then
     |Got a new date so do something with it.

GO Cards!
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.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote