filter expression with date AND TIME

[MajorTom]

Hello everybody

I using an dataview rowfilter expression to filter some record from one
dataset, is I only working with the date portion no problem, but how do I
use the date and the time for filter some records ?
the code that I have is like this one:

crit1 = "fecha >= #"+dtpDesde.Val ue.ToString("MM/DD/YYYY")+"#";
crit2 = "fecha <= #"+dtpHasta.Val ue.ToString("MM/DD/YYYY")+"#";
filtro = crit1 + " AND " + crit2 ;

my datetime picker dtpDesde and dtpHasta have the time in there format and
the field fecha is datetime and I want to filter by time to.

Please, any help ?

MajorTom

[Bob Grommes]

If the Value property of the controls is a datetime variable then just add
the time to the format string you already have. If the time is stored
separately then create a TimeSpan instance from the time value and add it to
the date, and then format it all together.

--Bob

"MajorTom" <m.********@NOv erizon.net.do> wrote in message
news:Ok******** ******@tk2msftn gp13.phx.gbl...

Hello everybody

I using an dataview rowfilter expression to filter some record from one
dataset, is I only working with the date portion no problem, but how do I
use the date and the time for filter some records ?
the code that I have is like this one:

crit1 = "fecha >= #"+dtpDesde.Val ue.ToString("MM/DD/YYYY")+"#";
crit2 = "fecha <= #"+dtpHasta.Val ue.ToString("MM/DD/YYYY")+"#";
filtro = crit1 + " AND " + crit2 ;

my datetime picker dtpDesde and dtpHasta have the time in there format and
the field fecha is datetime and I want to filter by time to.

Please, any help ?

MajorTom

[MajorTom]

thank for your help

like this:
....ToString("M M/dd/yyyy HH:mm")+"#";

I going to test it

Thanks againg

MajorTom

"Bob Grommes" <bo*@bobgrommes .com> wrote in message
news:#r******** ******@TK2MSFTN GP11.phx.gbl...

If the Value property of the controls is a datetime variable then just add
the time to the format string you already have. If the time is stored
separately then create a TimeSpan instance from the time value and add it to the date, and then format it all together.

--Bob

"MajorTom" <m.********@NOv erizon.net.do> wrote in message
news:Ok******** ******@tk2msftn gp13.phx.gbl...

Hello everybody

I using an dataview rowfilter expression to filter some record from one
dataset, is I only working with the date portion no problem, but how do I use the date and the time for filter some records ?
the code that I have is like this one:

crit1 = "fecha >= #"+dtpDesde.Val ue.ToString("MM/DD/YYYY")+"#";
crit2 = "fecha <= #"+dtpHasta.Val ue.ToString("MM/DD/YYYY")+"#";
filtro = crit1 + " AND " + crit2 ;

my datetime picker dtpDesde and dtpHasta have the time in there format and the field fecha is datetime and I want to filter by time to.

Please, any help ?

MajorTom