SQL query with date

[LinhNguyen]

Good morning, everyone!

I'm trying to run this SQL query to select data in a date range using the dynamic In DB tool. The workflow didn't show any error but still output all the date and not the date range that I specified.

Could you help me figure out the problem with this query?

Thanks!

[LordNeilLord]

Hey @LinhNguyen 

Shouldn't the query be FLDate < DatePY?

[LinhNguyen · Accepted solution]

I tried that and it didn't work, but then I tried FLDate > DATE '" + [DatePY]+ "' and it worked 😄