Passing a Date from RS to a View in the DB

[cognostechie]

Hi All -

Just like a Stored Procedure can accept a parameter as an input, can we pass a Prompt (in this case a Date value) to a View already created in the DB? I can cut and paste that view and use the 'Native' SQL but in that case, can we use some Macro etc to pass the Date Value as a Parameter to be chosen by the user?

Thanks

[cognostechie]

Found the solution. Embedding a Macro works. It makes the View execute AFTER receiving the value from the Macro so that works.