Use the expression "%Date" in the "Default Value" field; this will automatically populate the prompt with the current date when the query is run.