how to remove time value in the date

[siva58]

i have twi fields with name 1. start date 2. end date in the employee table

when i select the date it also capturing the time.

but i need date only.like below

can any one help me with the exact solution 

[Hitoshi Ozawa]

Siva,

Switching to type "Date" will loose the time values. This won't be a problem if the "start date" and "end date" is not dependent on time and there is no problem with time zone between users.

If the question is to keep type of those fields to Datetime and just to change the field display on one of the input form to show only date, a record producer may be created with input field type of Date that maps to the Datetime field in the table.

There is not option to show just the date part of datetime field on the form. It is also not possible with script either.