Restrict end date based on start date?

rambabu1 · ‎07-09-2020

In form 2 date/time fields.

1 for Start date & 2 is End date.

start date/time must be today or future.

End date/time cannot be same & past from start date?

Kunal Varkhede · ‎07-09-2020

Hi,

In addition to above, also check below

Simply done Using UI Policy and OnSubmit client script.

1)OnSubmit Client script

Check Start Date is less than End Date

function onSubmit() {
    var start_date = g_form.getValue('u_start_date'); //pass here your field backend name
    var end_date = g_form.getValue('u_end_date');//pass here your field backend name
    if (end_date < start_date) {
        alert("Start date is gretter than End Date ");
        return false;
    }
}

2)UI Policy

i) To check Start date is not past date must be future.

If it is past then clear that value using UI Policy.

ii)In UI Policy Action Clear date

iii) In script Section of Ui Policy

Check the Output in below screenshot

Please mark correct/helpful answer if it help you in any way.

Thanks,

Kunal

View solution in original post

Mouli Praneeth · ‎07-09-2020

You can achieve this from BR and set abort action if condition is true.

Thousif S N2 · ‎07-09-2020

You can achieve this by writing Onchange client script

rambabu1 · ‎07-09-2020

Can you help me on that.

Thousif S N2 · ‎07-09-2020

function onSubmit() {
//Type appropriate comment here, and begin script below
var start_d = getDateFromFormat(g_form.getValue('start_date'), g_user_date_time_format);

var end_d = getDateFromFormat(g_form.getValue('end_date'), g_user_date_time_format);

if (start_d > end_d && end_d != '') {

alert(g_form.getLabelOf("start_date") + " must be before " + g_form.getLabelOf("end_date"));
g_form.setValue('start_date', '');
return false;
}
}

I have written onSubmit client script for the start date but you can use same logic on onChange client script

Mark correct and helpful if it helps you

Thanks,

Thousif