0

How to Implement NEXT_DAY() function in Incorta

How to  implement   (next_day(sysdate,'SAT')-6) in Incorta Materialized View (MV) Query?

Dan Brock Anurag Malik

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi Alok,

     

    Hope it will work for you.

    Incorta Syntax:

    addDays($currentDate, -6)

     

    From this syntax you can add or minus the days, and use the "$ Variable" functions in case if you want to manipulate  weeks or years .

     

    Let me know its worked for you or not?

    Reply Like 1
Like Follow
  • 11 days agoLast active
  • 1Replies
  • 23Views
  • 2 Following