please help me modify command in view

See more:

SQL-Server

SQL-Server-2008

- I have a View, such as:

Create View vPrice As
Select 
	bg.PriceListID,			
	bg.ProductAttributeValue,
	bg.ProductName,
	bg.UnitID,
	bg.PriceValue,
	bg.DateFrom
From D14T1120 bg

- when i select this view, result as:

------------Select * from vPrice    ----------------------            
P..ID	P..lue  P...Name	UnitID	PriceValue	DateFrom
------------------------------------------------------------------------
BGIALE	893482	Heniken 	LON	5.0000	        2012-03-22 17:23:06
BGIALE	893482	Heniken 	LON	17.000		2012-02-08 17:23:06
BGIALE	893482	Heniken 	LON	17.500		2011-09-23 10:00:00
BGIALE	893482	Heniken 	LON	1		2011-09-09 07:50:12
BGIALE	893482	Heniken 	LON	16.000		2011-06-06 15:15:12
BGIALE	893482	Heniken 	LON	15.500.		NULL            

- please help me modify command in this view, more conditions: PriceValue >1 and DateFrom <=Getdate() (with today is 2012-03-21)

------------Select * from vPrice    ----------------------            
P..ID	P..lue  P...Name	UnitID	PriceValue	DateFrom
------------------------------------------------------------------------
BGIALE	893482	Heniken 	LON	17.000		2012-02-08 17:23:06
BGIALE	893482	Heniken 	LON	17.500		2011-09-23 10:00:00
BGIALE	893482	Heniken 	LON	16.000		2011-06-06 15:15:12

Regards