3 Replies Latest reply on Oct 23, 2018 5:37 AM by venkatram

    Setting up a date filter using 'By formula' for Tableau extract

    Bastiaan Brak

      hi all, couldn't find an answer to this query in the Forums so posting here hoping someone can help. I want to set up a date filter using the 'By formula' option from the Condition tab.

      From my dataset I want to filter out data for a bunch of dates prior to a fixed starting date as well as data for the current date. Currently, every time before refreshing the extract I'm manually unticking the 'previous current date' and ticking the 'current current date':

       

      When I use < TODAY() that results in syntax error:

      So in summary: how can I represent the equivalent filtering correctly via the 'By formula' option?

       

      Thanks, Bastiaan