>Can you prompt the user for data like the date from a stored procedure.

No. All SP's are executed on the Sql Server which runs as a service and doesn't have any GUI. You should prompt user for data on frontend and than pass it as parameters to SP.