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
Found the solution. Embedding a Macro works. It makes the View execute AFTER receiving the value from the Macro so that works.