I am trying to query my data coming from Salesforce. I'm suing the Salesforce input tool and I wanted to put my filter in the WHERE Clause(SOQL). I found a really helpful article in knowledge base called "
- Use dates to query incoming date from Salesforce: It has a link to the Date Literals you can use. To filter date on last year it says to use Date>LAST_YEAR
- Whenever I do this it pull the data that is greater than last year. If I use =LAST_YEAR I get a 400:Bad Request. I'm using Date=THIS_YEAR to pull 2020 data and it works fine.
- Does anyone have a suggestion on what I'm doing wrong for last year?
-
