> > Hello,
> >
> > I am attempting to use a local parameterized view with a date field for the parameter without any luck.
> > I am using Orders.shpdate >= {?dStart_Date} for the filter.
> >
> > This prompts for the date but does not result in a filter set. All of the records are presented.
> >
> > Is there some trick to using a date field as the parameter?
> >
> > Thanks for any suggestion.
> >
> > Judi
>
> Unfortunately you cannot do this. The InputBox (which is what is popped up for the parameter) returns a literal string, so you can only pass a character string or a numeric value through it. The way to handle a date is to create a little pop-up form to return the date parameter as a date and call it before you need the parameter so that it is already in scope when the view runs.
>
> Sorry, but I don't know of any other way to do it reliably.
>
> Regards
> Andy Kramek
> Microsoft MVP (Visual FoxPro)
> Tightline Computers Inc, Akron Ohio, USAAndy
Whereas your way is the only way to do it, it tried the method below at it actually worked
SQLEXEC(2,'select * from grr where date=?y::timestamp')
have to put the date in quotes in yyyy-mm-dd format. my backend was postgresql. but i would never use it in production.
Tushar