New to Alterxy: Filtering on Datetime field

Question

Hello,

I am a new Alteryx user.  My company is switching from SAS EG to Alteryx and I need to convert some rather complicated queries to Alteryx.  The databases I am pulling from are very large and I need to filter the data by a datetime field or it will try to pull in too much data.  That being said, I am struggling on executing this.  I'm not proficient at SQL either.  How can I filter from a datetime field before the Alteryx workflow pulls the data into the canvas?  I don't think it will work to first pull all the data in and then use the Filter tool, because there's too much data.  Below is a screen shot of the field I need to filter on. In SAS EG I could use the Query Builder function to select the correct date format at change the date.

I've tried this:

ACTIVITY_DATE >= '2021-01-01 00:00:00'

Thank you in advance!

RolandSchubert · Answer

Hi @Brost ,

it's a good idea to select only the data you need from your data source. Within the Data Input tool, you can build a SQL statement using the Visual Query Builder, switch to SQL Editor and add your condition to the statement (WHERE  ACTIVITY_DATE >= '2021-01-01 00:00:00' should work as expected).

Best,

Roland