Filter not working for DateTime columns with "equal To" filt

Unfortunately, I will not be able to give code, because it is still not clear in which layer (C# or SQL Server stored procedure) you are doing the comparison.

However, the concept is simple and it is as follows:

1/ User gives date in any format - dd/mm/yyyy mm/dd/yyyy but you must convert it to universally neutral date format yyyy-MM-dd.

2/ While doing comparison, always use BETWEEN (SQL Server) or > and < (C#).

3/ For comparison purpose you add the time part manually.

For example:

User gives 03-Oct-2016

You compare as : '03-Oct-2016 BETWEEN '03-Oct-2016 00:00:00' and '03-Oct-2016 23:59:59'.

Note that the time part we added is always hard coded and above expression returns true.

Hope it helps. Any more question(s), please do not hesitate to ask.

Hi,

Provide date formate in tostring like ,

hi nitin,

For a "date" column if user want to filter it through "equals to" filter, then it requires the time part too, but my requirement is ”User can filter it only with date rather than using time”, so can you please help me here,i am using intersoft grid

Try to stay away from .ToString() method of DataTime structure. The method relies on machine's locale settings which could be different on different machines. You code working on your machine is NOT guaranteed to work in production environment. Alternative is of course to universally neutral date formats such as yyyy-MM-dd HH:mm:ss etc.while in C# part.

One more thing, date is stored as an Integer in db. So statement like "The date time column in database is saved as '2013-07-26 00:01:09.840' format." is not quite correct. Is it only shown to you like that in whatever client you are using. Remember SQL Server Management Studio is also a client.

HI,

Where you compare, provide that code snippet..

DateTime dt = DateTime.MinValue;

string test = FilterText.Trim();

if(DateTime.TryParse(test, out dt))

return "#" + dt.ToString() + "#";

Hi Rao,

Provide your code snippet..