>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