1 Reply Latest reply on Oct 12, 2018 7:29 PM by arpine

    SQL for "Yesterday" in Insight?

    arpine

      Hi there! I am trying to create a simple report in Insight that would show me website visitors from yesterday - then subscribe to it and get it daily.

      The problem I'm running into is there is no way to set "Yesterday" in the visit date filter - it only accepts date values.

      I assume there is a way to write "Yesterday" in SQL (i.e. "Today" is "Current_Date") - but don't know how and broke my brain trying to figure it out.

       

      Anyone has a solution? Help is much appreciated!

      Thanks!