8 Replies Latest reply on Jan 8, 2015 1:31 PM by John Markley

    How to use datediff in Custom SQL

    John Markley

      I've got a rather simple custom SQL query driving a workbook, but I would like to speed it up by adding a WHERE clause to it that only looks at transactions with a complete date in the past 366 days.  I can't quite figure out how to add this to the actual query instead of using a relative filter after all data has been brought in.