Catalog UI Policy - end date cannot be before start date

Bird Petcharayu · ‎04-29-2021

Hello,

I need help. I am trying to use Catalog UI Policy to set the condition on the end date field. What I need is the end date cannot be before start date.

The field is "date" not "date/time"

I applied the condition as below for "end_date_of_visit" is more than 0 days after "starting date of visit" and use the client script BUT it doesn't work. The end date of visit field still can fill in the date before starting date.

Not sure that for this case, it's wrong on the condition I set or from the client script ?

Aman Singh_ · ‎04-29-2021

Hi,

Have you tried an alternative with the onchange client script on end_date.

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


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


  return;


  }

 var dFormat = g_user_date_format;

var end = getDateFromFormat(g_form.getValue('end_date'),dFormat);
var sDate=getDateFromFormat(g_form.getValue('start_date'),dFormat);

if(end<sDate)


  {


  alert(getMessage("End date should not be before Start date"));


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



  }


  


 



  }

Please mark Correct✅/helpful???? if applicable, thanks!!

Aman

View solution in original post

Kristen Dettman · ‎03-29-2024

Thanks for this! It's such a simple solution that doesn't require using a script include, etc. I was having the same issue with client script date comparisons not working properly, and this worked perfectly! The only thing I had to do was use "g_user_date_time_format" instead because mine was a date/time field.

Aman Singh_ · ‎04-29-2021

You can use the no-code approach to validate start date should not be before today

Create a UI policy as

Bird Petcharayu · ‎04-30-2021

Appreciate, it's workable.

Aman Singh_ · ‎04-30-2021

Glad to help!!,

Please mark the appropriate answer as correct and close the thread.

Thanks,

Aman

Bird Petcharayu · ‎04-30-2021

Found 1 thing that maybe tricky. it seems still be able to avoid UI policy if enter the end date first and start date later. It's allowed to input.

Do we have a script to validate the form ?