Hi Sandi

I hope you made your view like this...

Create Sql View v_SomeView As Select * From SomeTable Where DateField = ?lcDateParameter.

To run this view from the command window, just do this...

use v_SomeView nodata
lcDateParameter = date()
=requery()

HTH