>>>Hi Body
>>>
>>>I make a parameters view on a date field. when i define the variable before i use the view all work fine but when i let popup the dialog box who ask value of the variable it always give me bad date format.
>>>
>>>Do you know what i suppose to type to specify a date format?
>>>
>>>_____________________________________________________________
>>>
>>>CREATE SQL VIEW "TOTO" ;
>>> AS SELECT Nofacture ;
>>> FROM mp_data!Test ;
>>> WHERE DateDu <= ?pdvDate1
>>>____________________________________________________________
>>>
>>>Thank's in Advance
>>>Rock
>>
>>DId you try typeing the date in Curly Braces? {01/01/99}.. if you have stricdate set to 2 or 3 you will (may) need to use strict date {^1999-01-01}
>>
>>BOb
>
>Hi Bob
>
>If i set SET STRICTDATE to 0 {1999-01-01} work fine
>But if I set STRICTDATE to 1 {^1999-01-01} give me Strict Date Error.
>
>Do you Have another thing to try ?
>
>Rock

You are correct sir... I don't know why that does that... but, when I set stricdate to 2 and do this...

vp_dateparam = {^1999-01-01}
use myview

It works fine... perhaps you need to prompt for the date with your own form setting the StrictDate property of the textbox as you see fit. Don't know why this doesn't seem to work.

BOb