Help trying to filter in the Input Data tool

averyntxu

I'm trying to download data from an SAP HANA server and having trouble getting specific data from a date range.

Attached are the errors I'm receiving when trying to use the Criteria in the input tool.

Clearly, I'm doing this wrong, any help would be appreciated.

2021-01-22 08_33_11-Window.png

2021-01-22 08_36_49-Window.png

DavidP

Hi @averyntxu 

If I have to guess, it would be the date entered in the criteria field. The error suggests that it's seeing an integer where it's expecting a date. I'm not familiar with the required format, but that's what I would check first. Are there spaces between the year,month,date, does the whole date need to be in quotes like '2019-12-31' or that type of thing.