prevent a date field being a date prior to today

[patricklatella]

Hi everyone!

I have a date field Due date (due_date) on a custom table.   I need to prevent entering a date into this field that is prior to today.   To achieve this I've created a client script and an accompanying script include.   I believe I am close, anyone see why it's not working?   thanks!

my onChange client script is:

function onChange(control, oldValue, newValue, isLoading) {  

    if (isLoading || newValue == '') {  

          return;  

    }  

  //make sure they are not asking for a due date in the past (before now)  

  var ga = new GlideAjax("NowDateCalc"); //name of the called script include  

  ga.addParam("sysparm_name", "getNow"); //name of the function in the script include  

  ga.getXML(getDate); //callback function  

}  

function getDate(response) {  

  var due_date = g_form.getValue('due_date');   //due_date is the name of the field on the table

  var rightNow = response.responseXML.documentElement.getAttribute("answer");  

  if (due_date < rightNow) {  

  alert("Due date cannot be earlier than today.");  

  g_form.setValue('due_date', '');  

  }  

}

and my script include, "NowDateCalc" is:

var NowDateCalc = Class.create();

NowDateCalc.prototype = Object.extendsObject(global.AbstractAjaxProcessor, {

getNow : function() {

  return gs.now();

},

      type: 'NowDateCalc'

});

[Chuck Tomasi]

Correct. Business rules run on database triggers (record insert, update, delete, read). Client scripts are what you want, but they tend to be more touchy, especially with dates.

[patricklatella]

Hi Balaji,

thanks for the reply.   So with your client script do I still need the script include?

[Ujjawal Vishnoi]

No Patrick. As I see the above code, there is no need to use script include.

Regards

Ujjawal

[patricklatella]

that client script is working, however I want it to catch the due_date when the field is set, not when the form is saved or updated.   Is there something I can change to make it give the alert when the field is set?

[shloke04 · Accepted solution]

Hi,

You can simply do this with the help of UI Policy itself without much need of any script as shown below:

For example I have done this for Planned End Date on Change Request Table as shown below:

Result:

Post this Alert Message it will clear out the Field Value selected by the User also. Replace your Table Name and Field Name in the UI Policy shown above accordingly. This would work on click itself when the User selects the Date i.e. on Change of the field Value.

Hope this helps.Mark the answer as correct/helpful based on impact.

Regards,

Shloke