DataView and DateTime

[Jarod]

Hey
I have dtMessages dataTable and there is columnt DateTime, how can I compare
dates using DataView ? I need to compare hours more than dates. But the dates
are also needed because sometimes 02:00 will be after 23:50 and sometimes
before. So I initialize myTime = new DateTime.Now; and I need to compare it
with this column, it's initialized in the same way. But it doesn't work for
me when I check... :
..rowFilter = "Time <= " + time;
..rowFilter = "Time <= #" + time + "#";
..rowFilter = "Time <= '" + time + "'";

nor of this works for me, maybe you can help ?
Jarod

[Miha Markic [MVP C#]]

Hi Jarod,

You should use this format:
..rowFilter = "Time <= #yyyy/mm/dd hh:MM#"

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/
SLODUG - Slovene Developer Users Group www.codezone-si.info

"Jarod" <Ja***@discussions.microsoft.com> wrote in message
news:F8**********************************@microsof t.com...

Hey
I have dtMessages dataTable and there is columnt DateTime, how can I
compare
dates using DataView ? I need to compare hours more than dates. But the
dates
are also needed because sometimes 02:00 will be after 23:50 and sometimes
before. So I initialize myTime = new DateTime.Now; and I need to compare
it
with this column, it's initialized in the same way. But it doesn't work
for
me when I check... :
.rowFilter = "Time <= " + time;
.rowFilter = "Time <= #" + time + "#";
.rowFilter = "Time <= '" + time + "'";

nor of this works for me, maybe you can help ?
Jarod