[SOLVED] datachecks before saving business object

[bob_romijn]

Scenario:

A user is only allowed to enter an order release when the early delivery date is not within 2 (configurable) working days.

I have tried a few things with Action Checks, but that doesn't seem to work.

Has somebody have experience on this?

Best regards,

Bob Romijn

[samuellevin_mavenwire]

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