Problem Statement:

Sometimes we need to enter start time and end time under specific working hours.

For example: Doctor’s Appointment or Meeting Appointment available only 6 AM to 9 PM.
Here we will see how we can restrict the user to enter start time and end time using validation rule.

Solution:

1. First we need to create a formula field that will return the User’s GMT.

2. Now we need to create two DateTime fields to capture start time and end time.

3. Now create a validation rule to restrict user to enter start time and end time between 6 AM to 9 PM.

OUTPUT:

  1. User Locale

2. Try to Update Start Time and End Time. Even for one minute difference it will show error message.

OR

I hope guys you like my first blog. Please provide your valuable feedback below.

[jetpack_subscription_form subscribe_placeholder=”Enter your email address” show_subscribers_total=”false” button_on_newline=”false” submit_button_text=”Sign Up” custom_background_emailfield_color=”undefined” custom_background_button_color=”undefined” custom_text_button_color=”undefined” custom_font_size=”16″ custom_border_radius=”0″ custom_border_weight=”1″ custom_border_color=”undefined” custom_padding=”15″ custom_spacing=”10″ submit_button_classes=”” email_field_classes=”” show_only_email_and_button=”true” ]

Tagged in: