Nageshwar Rao

Nageshwar Rao

  • NA
  • 74
  • 37.8k

Filter by ignoring time from DateTime Field

Oct 6 2016 3:07 AM

Hi

Suppose in my database there is column named"MyDateTime of type DateTime
I want to show user both date & time So we can not do any change in itemsource for ignoring time from date in that field named MyDateTime

Now I am applying filter on that field(MyDateTime) in gridcontrol
I want to only consider date from field MyDateTime for filter

How to do Filter By ignoring Time from column type DateTime ?

If possible then please provide some example

I want to do this because problem is
Suppose in database there is data
15/05/2012 02:30:55

Now I am filtering for this data
If I sellect equals as operator from filter & select date 15/05/2012
then on backend it will select date like 15/05/2012 00:00:00 for filter
so it will not show any result because of time is different

I want to show user both date & time
But I want the filter only consider date from datetime field.Here i am using intersoftgrid

 

Can you please help me for that?


Answers (5)