AnsweredAssumed Answered

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

Question asked by pauhana658 on Apr 7, 2013
Latest reply on Apr 11, 2013 by 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!

Outcomes