I know this is weird, but have you tried using double quotes around the
date and time instead of single. I have run into cases where one worked and
the other didn't.
-----Original Message-----
From: Zehrung, Joe R. [SMTP:[EMAIL PROTECTED]]
Sent: Friday, June 18, 1999 3:44 PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: PFCSIG Date filter
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]
> [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]
