prevent a date field being a date prior to today

patricklatella
Mega Sage

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'

});

1 ACCEPTED SOLUTION

shloke04
Kilo Patron

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:



find_real_file.png



find_real_file.png



Result:



find_real_file.png



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


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

Regards,
Shloke

View solution in original post

18 REPLIES 18

Best practice is to take a scriptless solution over a scripted solution when both are available. It's easier to create and maintain. I strongly recommend reconsidering the scriptless business rule above. I use it all the time for date validation.

Pratik Malviya
Tera Guru

//Using On change client script.

 

function onChange(control, oldValue, newValue, isLoading, isTemplate) {
if (isLoading || newValue === '') {
return;
}

var serviceDate = getDateFromFormat(newValue, g_user_date_time_format);

var rightNow = new Date();

if (serviceDate < rightNow) {

alert('Service date cannot be in past please correct it');

g_form.clearValue("service_date");


}

}

 

//If it is helpfull, please mark it.

Thanks,

Pratiek Malviya

Please mark the appropriate response as correct answer and helpful, This may help other community users to follow correct solution.
Thanks,
Pratik Malviya

Nathan Storm
Kilo Contributor

After hours of trying to figure this out on my own from a Client Script perspective, this is exactly what i needed. Wish i would've found this in the beginning. bravo 

patricklatella
 
 

great to hear!