Problem with parameter in select statement

[krymat]

How do you get a parameter value to pass through to a column value?

The parameter is set though a DTS global variable

for example (simplified example)

Select
? AS TestDate,
a.store_number,
a.trans_number
From
transaction_master a
Where
a.fill_Date > ?

I get a Syntax error or access violation when I try to do this.

Let's say ? = '08/16/2001'

I want to result to be something like this:
TestDate store_number trans_number
08/16/2001 0754 01254
08/16/2001 0523 45485
etc....

s-)