1 Reply Latest reply on Aug 9, 2018 5:24 PM by TexasApexDeveloper

    How to force the minimum/maximum date checking for creation

    Kevin Zhang

      Hi All:

       

      APEX 5.1.3 question.

       

      I am having Sales Order form and it has an attribute called "Request Date", which is a DATE type column. I have specified "+1d" for the "Minimum Date" attribute, which means the minimum value is SYSDATE + 1

      However, I only want this minimum date check rule taking place when Sales Order is created, not after an Sales Order has been created ...

       

      How, when I modified an existing Sales Order, I got the error. I don't want this behavior ...

       

      Any suggestion how to avoid this?

       

      What I am looking is "DO NOT invoke Minimum Date checking" if I am modifying something that is already there. Only do this when I am creating it initially.

       

      Thanks!

       

      Kevin Zhang