0 Replies Latest reply on Jul 15, 2021 12:05 AM by Anurag Chourasia

    How to: Increment system date by 1 day in Informatica P360 Import Function?

    Anurag Chourasia New Member

      Hi All,

       

      My question is regarding Import Function available in Informatica P360 8.1. We have a use case where when a certain condition passes, we need to populate "SYSDATE + 1" in of the date column during Import.

       

      I can see we have  "NOW()" function available in Import function which gives the current system date and time but in my case we need to populate it with "SYSDATE+1".

       

      I tried "NOW() + 1" but it did not worked for me.

       

      Can you please guide me how to achieve this.

       

      Regards

      Anurag Chourasia