Date Filters not working correctly

Random

I am sending a request to fetch expenses with following requestJobDescription to fetch all expenses from last year and current year.

{"credentials":{"partnerUserID":"XXXX","partnerUserSecret":"XXXXXX"},"type":"file","onReceive":{"immediateResponse":["returnRandomFileName"]},"inputSettings":{"type":"combinedReportData","reportState":"Open","limit":10000,"filters":{"startDate":"2020-01-01","endDate":"2021-12-31"}},"outputSettings":{"fileExtension":"csv"}}

but the resulting file has no data. I do have an open report with unsubmitted expenses.

Zany Renney

Hey there @Random

Can you please write into us at [email protected] ?

This question seems like it would benefit from back and forth live chat which is easier to do there than in the Community.

Thanks!

Random

Thanks to awesome help from expensify support (I presume Zany?), it turned out to be a user error. I misunderstood the functionality of date filter. It is meant to filter by REPORT created/submitted date and not TRANSACTION created date.

To only select transactions matching certain criteria (including date), we should be filtering in template.

Thanks again for all the help.