found out the error in ur code, since the parameters of the datime
function receve
only date and time values, u havent changed it back to date and time
values after
stringing it!
try this
ls_filter = "data_dt > datetime(date('" +
string(ldt_setupdate,'mm/dd/yy')+"'),time('" +
string(TIME(ldt_setupdate)) + "') )"
see if this works!
i dont have an active pb interfac for me to check so i couldnt test it.
urs
naresh
"Zehrung, Joe R." wrote:
> I am having a problem setting up a date filter.
> I have a data window that has a column called 'data_dt' that is a
datetime
> type.
> The date I am to use as a filter is also a datetime field. I have
tried a
> number of different combinations and this is the one that seem to
be
correct
> but I keep getting a error that it need another ')' to end the
function. I
> have add additional ones but always get the same error.
>
> ls_filter = "data_dt > datetime('" + string(ldt_setupdate,'mm/dd/yy')+
"',
> '" &
>
+ string(TIME(ldt_setupdate)) + "'
) "
>
> If I display the filter at this point it reads data_dt
>
> datetime('10/02/98','00:00:00')
>
> adw_datawindow.setfilter(ls_filter)
> adw_datawindow.filter()
>
> Can anyone see anything wrong, Is there a better way to do this?
(must
be
> this is not working)
>
> Thanks
>
> joez
>
> joe r zehrung
> ph: 925-246-5982
> dsn: 350-5982
> e-mail: [EMAIL PROTECTED]
>
> > [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE
COMMANDS, ADDRESS
> > A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE:
help
pfcsig
> > SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
