Thursday, November 8, 2018

Correct Method to Enter Time in a Custom Field with Type = Time of Day

When Users enter a 12'O Clock variation (i.e. 12:00, 12:15, 12:30, 12:45) the time is post fixed with 'AM' rather than 'PM'

The Time Format set in Home > Set Preferences > General tab is set to either hh:mm AM/PM or hh-mm AM/PM.

1. Navigate to Setup > Customization > Entity Fields > New.
2. Set Label = Exact Time.
3. Type = Time Of Day.
4. Store Value = True.
5. Applies To Tab = Example: Customer.
6. Display Tab > Subtab = Main.
7. Click Save.
8. Navigate to Lists > Relationships > Customers > New.
9. Exact Time field: Enter 0000 to 2359.
10. Then Click Tab.

Example:
A. Enter 0000 > Click Tab = 12:00 am
B. Enter 0515 > Click Tab = 05:15 am
C. Enter 1200 > Click Tab = 12:00 pm
D. Enter 1850 > Click Tab = 6:50 pm
E. Enter 1890 > Click Tab = 7:30 pm
F. Enter 2359 > Click Tab = 11:59 pm

Note: Entering Numbers 2400 and more will display incorrect data
- System is designed to associate time within 24 hours only

 

No comments:

Post a Comment