How to add validation to date only field on a form

(0) Share

Report

Posted on by Sol007

187

Hi there,

As per requirement, is there a way to add validation to a date only field on a model driven app form so that only today's date and future dates can be selected on the field through OOTB workflow? Or is it easier with applying business rule logic.Any further guidance or method is appreciated, thanks in advance.

I have the same question (0)

All responses (14)

Answers (1)

Suggested answer

Amit Katariya007 10,409 Super User 2025 Season 2 on at

Like (1)

Report

RE: How to add validation to date only field on a form

Hello,

Unfortunately this is a limitation, But you you can achieve using the customization.

Please follow below steps.

1. Create a Date field which should be type as calculated and populate this field with current date.

Then click on the edit and apply below Action.

2. Add this field on the form and make it as the hidden.

3. Then create a business rule and add the below condition.

So if user will select the Past date then above error will show and it will clear the Date field.

4. This is how it will show if user will select the Past date.

Thank you,

Amit Katariya

Was this reply helpful? Yes No
Sol007 187 on at

Like (0)

Report

RE: How to add validation to date only field on a form

Thanks Amit Katariya, will give this a try. I thought this may not be completely achieved by Business rule and was trying to avoid any coding but started looking if applying js code onload of the form would achieve it.

Was this reply helpful? Yes No
Verified answer

Amit Katariya007 10,409 Super User 2025 Season 2 on at

Like (1)

Report

RE: How to add validation to date only field on a form

Hello,

I have try to implement above scenario with the JS Code But the issue arises when you will try to add the code on change of field.

I have already tried this solution but because of on change event the pop up was showing multiple times...…and we can not avoid it. So Business rule will be the best solution..,

Thank you,

Amit Katariya

Was this reply helpful? Yes No
Sol007 187 on at

Like (0)

Report

RE: How to add validation to date only field on a form

Hi Amit Katariya, the validation does not appear to work if you enter a past date it is still storing the record on the table. The Now() calculated field seems not to work in BR? Maybe JS?

Was this reply helpful? Yes No
Suggested answer

Amit Katariya007 10,409 Super User 2025 Season 2 on at

Like (0)

Report

RE: How to add validation to date only field on a form

Have you followed all 3 steps which are mentioned in the Business rule. Please consider "Date" field as your existing field and "Today's Date" as the new field(Make it as hidden on the form) which you will need to create.

You will need to use Now() function which will populate current date in "Today's Date" automatically because it is calculated field.

and Last but not least we have BR which will compare existing "Date" field and "Today's Date" field.

if "Date" field is less than "Today's Date" field then it will clear the "Date" field and also show the error message.

Was this reply helpful? Yes No
Sol007 187 on at

Like (0)

Report

RE: How to add validation to date only field on a form

Hi Amit Katariya, yes I did see screenshot below. When I select a past date on the field I have to click save for the error message to appear and the past date is stored in the record table until I select a current or future date for it to clear.

I am giving js code on the field a try now: please someone help me with what js function I need to pass for the current date not to error? If I select a past date I get the error notification also when I select a current date (today) I still get same error

Thanks in advance

Was this reply helpful? Yes No
Suggested answer

Amit Katariya007 10,409 Super User 2025 Season 2 on at

Like (0)

Report

RE: How to add validation to date only field on a form

Hello,

have set the scope of Business rule correctly?

Because if it is not set correctly then it will not work. you can set as entity/all form/form specific

Was this reply helpful? Yes No
Sol007 187 on at

Like (0)

Report

RE: How to add validation to date only field on a form

Hi, the scope of the Business rule is set correctly to form specific.

Was this reply helpful? Yes No
Suggested answer

Amit Katariya007 10,409 Super User 2025 Season 2 on at

Like (0)

Report

RE: How to add validation to date only field on a form

Does both fields Like Old date field and new one is added/ present on the form ?

Was this reply helpful? Yes No
Sol007 187 on at

Like (0)

Report

RE: How to add validation to date only field on a form

Yes, old date field is visible on the form and new one that was added on the form is hidden.

Was this reply helpful? Yes No