Insert Date into parameter

[sbbrown9924]

I have a SQL query:

SELECT *
FROM Archive
WHERE (TXFlag=1 OR TXFlag=-1 OR TXFlag=2) AND (TriageTime BETWEEN #KTparam1# AND #KTparam2#)

where KTparam1 has a runtime value of DateBegin, a form text field where the user inserts a date and a default date of 1/1/2006.

KTparam2 has a runtime value of DateEnd, also a text field where the user inserts a date value. I would like the default value for KTparam2 to be today's date. How would I make that work for the parameter KTparam2? Thanks.

 

[dodge20]

in access give a date a default value of
Now()

Or if you can do it with asp or php

in asp assign your text box a value of
<%=date()%>

Dodge20