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.