>>>Jim,
>>>I'm surprised too. You're right in designer it sucks and no clue. I never use it and wasn't aware of it. It even denies date(1990,1,1).
>>>Cetin
>>
>>Jim,
>>Not only in designer. It behaves like that whenever you try to open view :( Hope someone has solution for it.
>>Cetin
>
>Whew. I'm glad you can reproduce the problem. The view works perfectly in my runtime as I pre-define the variable, then call the view. This is a real pain in the neck while designing/testing the view, however...

Jim,

I searched here by date view parameterized. I found this message Forum: Visual FoxPro Category: Databases,Tables, Views, Indexing and SQL syntax Title: Re: Views created on other views Thread #438540 Message #438631 and another in the thread "Strict date" by Fred Taylor.

Try to search here, I remember this problem was discussed.