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?

    Like 1
Like Follow
  • 8 mths agoLast active
  • 1Replies
  • 40Views
  • 2 Following

Product Announcement

We are happy to
announce Incorta 4.8 !!!