SQL & passing in ONE parameter (without using pivot table)

So I have:

Excel 15.
An excel sheet, linked to a Postgres DB
I am pulling data successfully into the XLS, via ODBC

Objective

Pass in ONE parameter (UserName) and use that in the query

The way I use the queries is
- Data -> New DB Query
- in MS Query, paste in my SQL (which works)

Next is the Import Data screen, which lets me put the data into the sheet
That all works.

How do I pass in a parameter?
In MS Support "Customize a parameter query"

The article indicates a parameter can be passed in, but I dont understand how.

Ideally, I like to have a cell with my input parameter to be used in the SQL
(I can pick that up via VBA if needed. My VBA is decent)


Thanks

Originally Posted by xlnitwit

Hi,
You need to edit the SQL to add ? as the parameter. That will then enable the Parameters option for the query and you can link it to a cell.

Do you have an example?

thanks

OK - a simplified version, where I want to pass in DATE

SELECT
u."createdAt" AT TIME ZONE 'America/Toronto' AS "Sign Up Date",
U.first_name as "First",
U.last_name as "Last",

from users U

WHERE (U."createdAt" AT TIME ZONE 'America/Toronto')>= DATE



Thanks for the help

So I did that exactly. passed in a number using the pop up parameters box
and got the following error

Days Back.png

Guessing here that its passing in a String rather than an integer.
Not sure how to specify that.