My select statement has a date field in it, and I want to use this field as one of
my fields in the dbFilterFlds. How does the filter handle a
WHERE maindate BETWEEN date1 AND date2; ????
Printable View
My select statement has a date field in it, and I want to use this field as one of
my fields in the dbFilterFlds. How does the filter handle a
WHERE maindate BETWEEN date1 AND date2; ????
Hello,
We have numerous example where we have a date field and can do filtering
without any problem. Using Pro, you can see an example at:
http://www.aspdb.com/demo5.asp
Click Filter then enter a 'HireDate > 1/1/94' and it will work fine.
Using Enterprise, you have more flexibilty, but you're required to "wrap"
the dates in "#" characters. Go to:
http://www.aspdb.com/V2/V2_Nav_Rows.asp
Click filter, then enter this in the HireDate field:
> #1/1/94# and < #1/1/95#
This is the "between" function you're looking for right? You can also
express this as:
BETWEEN #1/1/94# AND #1/1/95#
This exact syntax is shown in the yellow help box at the bottom of that page.
Thanks,
John
------------
G. Zanganeh at 9/29/99 11:11:51 AM
My select statement has a date field in it, and I want to use this field as one of
my fields in the dbFilterFlds. How does the filter handle a
WHERE maindate BETWEEN date1 AND date2; ????
I only have View and using Oracle with its DD-MON-YY format. Will the same still apply?
thanks for your help.
------------
John at 9/30/99 3:10:47 PM
Hello,
We have numerous example where we have a date field and can do filtering
without any problem. Using Pro, you can see an example at:
http://www.aspdb.com/demo5.asp
Click Filter then enter a 'HireDate > 1/1/94' and it will work fine.
Using Enterprise, you have more flexibilty, but you're required to "wrap"
the dates in "#" characters. Go to:
http://www.aspdb.com/V2/V2_Nav_Rows.asp
Click filter, then enter this in the HireDate field:
> #1/1/94# and < #1/1/95#
This is the "between" function you're looking for right? You can also
express this as:
BETWEEN #1/1/94# AND #1/1/95#
This exact syntax is shown in the yellow help box at the bottom of that page.
Thanks,
John
------------
G. Zanganeh at 9/29/99 11:11:51 AM
My select statement has a date field in it, and I want to use this field as one of
my fields in the dbFilterFlds. How does the filter handle a
WHERE maindate BETWEEN date1 AND date2; ????
ORACLE and SYBASE dates will be supported in the next release.
Frank
------------
zanganeh at 10/1/99 6:51:53 AM
I only have View and using Oracle with its DD-MON-YY format. Will the same still apply?
thanks for your help.
------------
John at 9/30/99 3:10:47 PM
Hello,
We have numerous example where we have a date field and can do filtering
without any problem. Using Pro, you can see an example at:
http://www.aspdb.com/demo5.asp
Click Filter then enter a 'HireDate > 1/1/94' and it will work fine.
Using Enterprise, you have more flexibilty, but you're required to "wrap"
the dates in "#" characters. Go to:
http://www.aspdb.com/V2/V2_Nav_Rows.asp
Click filter, then enter this in the HireDate field:
> #1/1/94# and < #1/1/95#
This is the "between" function you're looking for right? You can also
express this as:
BETWEEN #1/1/94# AND #1/1/95#
This exact syntax is shown in the yellow help box at the bottom of that page.
Thanks,
John
------------
G. Zanganeh at 9/29/99 11:11:51 AM
My select statement has a date field in it, and I want to use this field as one of
my fields in the dbFilterFlds. How does the filter handle a
WHERE maindate BETWEEN date1 AND date2; ????