Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Use SOQL clause to query incoming date from Salesforce

crouchsonia
7 - Meteor

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?
  •  
1 REPLY 1
crouchsonia
7 - Meteor

I found a solution.  CALENDAR_YEAR() = 2019

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels