Hi Gnana,
Did you define the parameter as a Date?
In the View Designer, in the Query menu / View Parameters sub-menu, you can define the datatype of your parameters.
Or, in code use something like
DBSetProp(ViewName, 'View', 'ParameterList', "Parm_Date,'D'")
HTH,
>Hi folks,
>
>I have a parametised view with filter set to date column. while running the view ,it prompts for the value but doesn't accept any of the date format. I have tried {mm/dd/yy}, {^yyyy/mm/dd}, gives operand mismatch /ambiguous date /datetime constant errors.
>
>I am wondering how to use date column in where clause of the select statement.
>
>Thanks
>Gnana.
Bill Armbrecht
VFP MCP