View Single Post
  #2 (permalink)  
Old April 26th, 2007, 15:18
samuellevin_mavenwire samuellevin_mavenwire is offline
Junior Member
 
Join Date: Aug 2006
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
samuellevin_mavenwire is on a distinguished road
Wink Re: datachecks before saving business object

The challenge here is with the working days. Its hard through a query to handle calendar days against a system date. I have done action checks around dates like the following
TRUNC (o.early_pickup_date) - TRUNC (SYSDATE) <=2

Hope this helps!
Sam