No OOTB way to validate date selected isn't before TODAY?

(0) Share

Report

Posted on by Cyclefitness

I must be missing this very basic requirement to validate the date a user enters isn't before TODAY. I can't see where this is possible with Business Rules. Am I missing something?

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (2)

Suggested answer

razdynamics 17,308 User Group Leader on at

Like (1)

Report

Hi Debra

You will need to use the following JS to perform this validation;

Function Form_onsave(executionObj)

{

var shouldSave = true;

if (shouldSave)

{

var contactDate = Xrm.Page.getAttribute('new_nextcontactdate').getValue();

if (contactDate != null) {

contactDate.setHours(0, 0, 0, 0);

// rest of the code

var today = new Date();

today.setHours(0, 0, 0, 0);

if (contactDate < today) {

alert("Date can not be less than today");

executionObj.getEventArgs().preventDefault();

}

}

}

I hope that helps :)

Best Wishes, Raz

Was this reply helpful? Yes No
Verified answer

Neil Benson 7,369 User Group Leader on at

Like (0)

Report
The Business Rules feature doesn't provide a method for configuring every possible business rule you might have (unfortunately).

The two options I would evaluate are:

A custom JavaScript function that fires when the date field is changed and displays an alert to the user.

A third-party add-on, such as North52, that enables non-developers to configure custom business rules.

Was this reply helpful? Yes No
Verified answer

xrmbase on at

Like (1)

Report

Best OOTB way is to create a Real Time Workflow-

Check condition - If "date field" is less than or equal to [process] 'execution time.

Then Stop workflow with status = cancelled [set properties for eg: "Date should be in Future only"]

Was this reply helpful? Yes No
Cyclefitness on at

Like (1)

Report

I like this xrmbase; thank you. I'm always looking to push the envelope with OOTB. I didn't realize that Process value was available.

Was this reply helpful? Yes No
Suggested answer

Anup Maharjan 5 on at

Like (0)

Report

Well dynamics should have develop the validations that appears with the date and time field in the form controls.

Anyway, there is alternate solution to this.

1st Step: we need JS to record current time to any required field in the form onLoad (onLoad will update the current time every time the form is loaded).

function setCurrentDate(eContext, dateField) {
var formContext = eContext.getFormContext();
formContext.getAttribute(dateField).setValue(new Date());

--- this JS can be used globally (in any entity), in the JS you have to parse the date/date-time field's id that will appear in "dateFiled".

2nd Step: Configure the field and Business Rule validating with above field.

Congratulation you are done.

Suggestion to microsoft.

You can add current date time field to global util of d365 and make available in every entity, or else develop addition function in controls of datetime field in the form.

Was this reply helpful? Yes No