create view

I am trying to create view with select stmt and in the where condition is to dynamically select date from one of the table.

But I am unable to do that.

Also,

I tried to create procedure and declare vairables and tried to use

that variable in the where condition of the Select Clause in the Create View

but got an error

Incorrect syntax near the keyword 'VIEW'.

Can I create procedure to create view?

Can I use dynamic variable in the Select ...where..clause of the View?

How do I do?

A repro script would have helped. Take a look at table-valued functions. This might help in your case.