Sorting and Filtering dates in a Dataview

[Usarian Skiff]

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 Ligthert]

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 Markic [MVP C#]]

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#"

 

[Usarian Skiff]

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 Skiff]

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 Ligthert]

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