How to specify a report to pull a previous date to current date in Table Query in Alteryx?

[blitz45]

I'm trying to schedule my workflow to pull in data from a previous year to current date using the Table Query visual option. 

Does anyone know that syntax in SQL?

[cplewis90 · Accepted solution]

In SQL do you have a table that has calendar dimensions?

You could pull the first day from that table and pull data after that up to current_date.