Hi, i'm having problems filtering DateTime Fields in tables, since SQL views dates as:

Jul 3 1991 12:00AM

I'm using C# code, and my dates are in Date.Time format. (01/01/1900) Is there any simple way, whitout hard-coded implement the decoding of the Date.Time object?

Use the DateTimeField's Date property to get the Date with the time set to 00:00:00.

i also have the problem of filtering data on the basis of date and time please explain in little bit clear words

Hi, i'm having problems filtering DateTime Fields in tables, since SQL views dates as:

Jul 3 1991 12:00AM

I'm using C# code, and my dates are in Date.Time format. (01/01/1900) Is there any simple way, whitout hard-coded implement the decoding of the Date.Time object?

If you want to execlude the time part on the database, you may use a DBFunctionCall to call for the SQL Server Function DATEPART() to use the DATE part only.

What i can do to get only the Day part and the Month part of the DateTime Field with oracle database?

Use a DBFunctionCall to the appropriate Oracle function.

next time, please start a new thread, rather than using an old one.

Thanks alot Walaa

I have wrote the following code and works fine.

EntityField dayField = new EntityField("Day", new DbFunctionCall("To_Char", new object[] { CustomerFields.BirthDate, "DD" }));
                    EntityField monthField = new EntityField("Month", new DbFunctionCall("To_Char", new object[] { CustomerFields.BirthDate, "MM" }));

                    filter.Add(dayField == BirthDateTimePicker.Value.Day);
                    filter.Add(monthField == BirthDateTimePicker.Value.Month);