Time showing for date fields

[mday]

Date fields are being formated to display the date and time when displaying the results and in the where clause. How do I get the dates to display only?

[Admin]

Select "date" data type for your attribute in the model instead of "date/time"

[mday]

The fields in the database are of type "Date" but are being displayed in the results table with a time. The time being set to "00:00:00". Is there somewhere where I can format the display of these dates to not include the time and in a format of my choice instead of mm/dd/yyyy? It looks strange for some fields like 'dateOfBirth' to contain a time. The same date fields are being used in the where clause and show no times.

[Admin]

It happens because they have date/time type in your database.

I think there must be some properties in DataGrid component (or any other control you use to show the result of the query) which allows you to change the formats of the shown data.

[mday]

Thanks for your reply. I managed to format the dates for the grid control.