Hi Christian,
SET STRICTDATE TO 0
or send the parameter DATETIME() instead of DATE().
HTH.
>HI,
>I try to requery a parametrized local view. The parameter is date datatype. When I issue : =REQUERY("MyView"), I receive an error message :
>" Ambiguous date/datetime constant. Use the format:
> {^yyyy-mm-dd[,][hh[:mm[:ss]] [a|p]]}"
>
>I even receive this message when I use DATE() as parameter. How should I format the parameter to make it valid ?
>
>Thank you,
>Christian Cote
Evan Pauley, MCP
Positronic Technology Systems LLC
Knoxville, TN
If a vegetarian eats vegetables, what does a humanitarian eat?