Sorting and Filtering dates in a Dataview

I'm trying to filter a range of dates in a dataview.

Problem is single digit days and months are getting mixed in with double
digit days and months.

eg) rowfilter='DT>03/25/2005 AND <03/27/2005'

returns anything with a date of 03/2/2005 along with what it should return.

any fixes?

Cor
Thu Feb 17 13:31:51 CST 2005

Usarian,

> eg) rowfilter='DT>03/25/2005 AND <03/27/2005'

I seldom try that one anymore, does this give the same effect

rowfilter='DT>03/25/2005 AND DT <03/27/2005'

Cor

Miha
Thu Feb 17 13:31:59 CST 2005

Hi Usurian,

Read
DataColumn.Expression property
.net help topic.

Extract:
User-defined values may be used within expressions to be compared against
column values. String values should be enclosed within single quotes. Date
values should be enclosed within pound signs (#). Decimals and scientific
notation are permissible for numeric values. For example:

"Birthdate < #1/31/82#"


--
Miha Markic [MVP C#] - RightHand .NET consulting & development
www.rthand.com
SLODUG - Slovene Developer Users Group www.codezone-si.info

"Usarian Skiff" <usarian.skiff@servicecentermetals.com> wrote in message
news:%23xjAqCSFFHA.1396@tk2msftngp13.phx.gbl...
> I'm trying to filter a range of dates in a dataview.
>
> Problem is single digit days and months are getting mixed in with double
> digit days and months.
>
> eg) rowfilter='DT>03/25/2005 AND <03/27/2005'
>
> returns anything with a date of 03/2/2005 along with what it should
> return.
>
> any fixes?
>
>

Usarian
Thu Feb 17 13:41:04 CST 2005

> I seldom try that one anymore, does this give the same effect
>
> rowfilter='DT>03/25/2005 AND DT <03/27/2005'


Sorry, That's actually what I'm doing now.
Is this normal even? When I sort a dataview by date I get the same thing..
where the single digit dates are intermingled with the double digits when
the singler is a match to the tens position. (2x = 2)
It's driving me mad. every application I create I run into this issue.

Usarian

Usarian
Thu Feb 17 13:42:21 CST 2005

> Read
> DataColumn.Expression property
> .net help topic.
>
> Extract:
> User-defined values may be used within expressions to be compared against
> column values. String values should be enclosed within single quotes. Date
> values should be enclosed within pound signs (#). Decimals and scientific
> notation are permissible for numeric values. For example:
>
> "Birthdate < #1/31/82#"


Thank you SO much! You have restored my sanity!

Usarian

Cor
Fri Feb 18 01:45:34 CST 2005

Usarian,

Will you please be so kind to place questions not multiposted however when
relevant crossposted
Sending 1 message to more newsgroups in a time.

Now there were 4 people giving you an answer, where you now did not even
tell that Jay B. Harlow's answer did fit your question exactly in the
newsgroup languages.vb

Thanks in advance.

Cor