1 Reply Latest reply: Feb 17, 2013 8:32 AM by Kalimuthu V-Oracle RSS

    To get the sysdate into a msg text input  field by default ................

    Dev586
      Hi all.....

      my requirement is simple yet a bit complicated...

      i need to get the SYSDATE as default into the field which is of data type DATE...

      I was successful in getting it by writing the following code in AMimpl......

      OADBTransaction txn=(OADBTransaction)getOADBTransaction();+
      oracle.jbo.domain.Date currentDate=txn.getCurrentUserDate();+
      row.setAttribute("ClosingDate",currentDate);+


      its taking the value (2013-02-16 10:17:09.0) in this format and it is saving in the back end as the same.....

      when i am running the SEARCH page
      and
      use this CURRENTDATE as the search criteria......
      it is taking the value (2013-02-16 12:00:00.0)

      So i am unable to get the result i desire

      if i select a particular date
      could any one help me in this particular CASE......

      With regards
      DEV