Named Queries with start date and end date question

Is there a way to used named queries with a start and end date. Something like this?

I think i have and error in the queries.

If there is a way to do that. Can there be a way to use the named query can be used as a data Sources in a report using the Parameters?
Something like this:

I think I’m doing something wrong here but let me know if I can even do this?

Looks fine as far as the parameters go. Most SQL DB’s I’m familiar with will fail if the WHERE clause is after the ORDER BY clause. The error you are getting probably says so. (Show the error next time so we don’t have to guess.)

I fixed the query:

(I saw there WHERE as I posted it)

Here is the error:

Moved the where clause too far up. DB’s don’t like them before the FROM clause, either. Consider looking at the manual of your DB for the strict syntax diagram for SELECT queries. (As suggested by the error message, too.)

1 Like

Thanks, Not getting the error anymore just not getting data, That might be user error.