Use SOQL clause to query incoming date from Salesforce

[crouchsonia]

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?
•  

[crouchsonia · Accepted solution]

I found a solution.  CALENDAR_YEAR() = 2019