Sorting and Filtering dates in a Dataview

  • Thread starter Thread starter Usarian Skiff
  • Start date Start date
U

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?
 
Usarian,
eg) rowfilter='DT>03/25/2005 AND <03/27/2005'
Click to expand...

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

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

Cor
 
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#"
 
I seldom try that one anymore, does this give the same effect
rowfilter='DT>03/25/2005 AND DT <03/27/2005'
Click to expand...


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
 
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#"
Click to expand...


Thank you SO much! You have restored my sanity!

Usarian
 
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
 
Back
Top