0 Replies Latest reply: Jun 28, 2014 6:55 AM by 9b49467a-c3bc-424a-9140-690a42703f63 RSS

    Calculation Problem

    9b49467a-c3bc-424a-9140-690a42703f63

      Hello,

      I'm a new APEX user. My question is:

      Where i have to put my formula for the "Days" Column in Days Properties "TRUNC(SYSDATE)-TO_DATE(:P35_ORDERDATE, 'DD-MM-YY')" to get the Date Difference between SysDate and OderDate. That the form on this table shows me the difference in Days in the Days Collumn.

      [URL=http://www.directupload.net/file/d/3667/mk8y8e6w_png.htm][IMG]http://s14.directupload.net/images/140628/temp/mk8y8e6w.png[/IMG][/URL]

       

      I know that it works,

      I've done it before but now i cannot find these settings

       

       

       

      I'm very thankful for help

      StudMark