How can I limit a DATE field from being populated with invalid dates

[Hola Ola]

Happy Friday All, 

How can I prevent users from populating a DATE field with a date No Less That 5 Business Days (7 Total days from today) and No More Than 10 Business days (14 Total days from today).

Thank you for your anticipated help. 

[Voona Rohila]

Hi @Hola Ola 

Add Below condition

In Execute if False part of the code, Use your script to clear the value.

function onCondition() {
g_form.clearValue(period_duration_required_for_the_requested_access);
g_form.showErrorBox('period_duration_required_for_the_requested_access', getMessage('Date should be 7 - 14 days in the future'));
}

[Hola Ola]

Hello @Voona Rohila ,

Thanks for your response and my sincere apologies for the bother. This is still not working as I had hoped. 

I'm sure I'm not doing something right here.

I used the script you provided and the Conditions. Am I missing something in the Execute if false box?

__________________________________________________________________________

[Voona Rohila]

Use below code in Execute if false.

function onCondition() {
g_form.clearValue(period_duration_required_for_the_requested_access);
g_form.showErrorBox('period_duration_required_for_the_requested_access', getMessage('Date should be 7 - 14 days in the future'));
}

[Hola Ola]

Hello @Voona Rohila 

Thank you for sticking with me. 

The issue I'm still having is demonstrated below:

Pic 1: I have the field showing the message

PIC 2: The Field still accepts a date that is only 3 days away (I am trying to restrict it to no earlier than 7 days and no later than 14 days).

Please tell me what I'm doing very wrong. 

[Voona Rohila]

@Hola Ola  - I will implement and share the details.

Your date field should accept after 7-14 days only right?