Date Questions

[G. Zanganeh]

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; ????

[John]

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 &#34;between&#34; function you&#39;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; ????

[zanganeh]

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 &#39;HireDate > 1/1/94&#39; and it will work fine.

Using Enterprise, you have more flexibilty, but you&#39;re required to &#34;wrap&#34;
the dates in &#34;#&#34; 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 &#34;between&#34; function you&#39;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; ????

[Frank]

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 &#39;HireDate > 1/1/94&#39; and it will work fine.

Using Enterprise, you have more flexibilty, but you&#39;re required to &#34;wrap&#34;
the dates in &#34;#&#34; 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 &#34;between&#34; function you&#39;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; ????