6 Replies Latest reply on Apr 11, 2013 11:10 PM by pauhana658

    Data entry filter for time field? Also delete seconds value?

    pauhana658

      Title

      Data entry filter for time field? Also delete seconds value?

      Post

           How do I create a data entry filter for a time field so that a user can enter "0845" and the field will automatically format it as "08:45"? 

           Related to this, the time is automatically entered in the field when a new record is created. This time displays as "08:45", but when the field is clicked, the time displays as "08:45:26". I don't need the seconds and the user may be confused and think a seconds value also must be entered. Is there any way to prevent this seconds value from being entered automatically when a new record is created, or simply not display it when the field is modified? Would this be related to the data entry filter I want to add to this time field?

           Thanks!