How to configure a catalog client scripts for the duration of two dates on catalog item?

A Icen · ‎03-26-2024

hi everyone,

I have a catolog item in which the duration time difference is calculated and populated when start and end date are picked up. I need a catalog client scripts, I have attached the screen to give you an idea what I need exactly.

Thanks

A Icen · ‎04-02-2024

Hi

The previous code did not work.

I have configured the code below, and it worked as I did want. Just keep in mind that use this code for both start date and end date on variable (not duration)

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

// Get the values of start_date and end_date fields

// Check if both fromDate and toDate have valid values

if (g_form.getValue('start_date') && g_form.getValue('end_date')) {

var fromDate = g_form.getValue('start_date');

var fromDateValues = fromDate.split('/');

var toDate = g_form.getValue('end_date');

var toDateValues = toDate.split('/');

// Create Date objects for start_date and end_date

var fromDateObj = new Date(fromDateValues[2], fromDateValues[1], fromDateValues[0]);

var toDateObj = new Date(toDateValues[2], toDateValues[1], toDateValues[0]);

// Calculate the difference in milliseconds

var timeDifference = toDateObj.getTime() - fromDateObj.getTime();

// Convert milliseconds to days

var daysDifference = timeDifference / (1000 * 3600 * 24);

// Round the result to get the total number of days

var totalDays = Math.round(daysDifference);

// Set the value of the 'duration' field

g_form.setValue('duration', totalDays);

}

View solution in original post

Maddysunil · ‎03-29-2024

@A Icen

If you need the difference on change of end date then in the variable name below the catalog item field select 'end date' and try once.

Please Mark ✅Correct if this solves your query and also mark 👍Helpful if you find my response worthy based on the impact.

Thanks