
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-14-2016 11:09 AM
I have a need to make sure that the duration between the Begin Date and End Date does not exceed 1 year.
I used scripting before to make a date go out to xxx amount of days, but never to actually do a calculation between Begin and End dates
I don't have a Due Date field. I just have the Start and End Date field and I need to make sure that Duration cannot exceed 1 year.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-14-2016 11:22 AM
Hello Karen, its been a while hope you are well!
Here is some example code I have used before. Do you want the validation to happen on submit or as the user is inputting the data? My code below is based on an onChange of the Work End date on a task, but you could change it to an onSubmit can calculate and warn then.
Create a onChange client script for the End date:
function onChange(control, oldValue, newValue, isLoading, isTemplate) {
if (isLoading || newValue == '') {
return;
}
var starts = g_form.getValue('work_start');
startMillis = getDateFromFormat(starts, g_user_date_time_format);
var ends = newValue;
endMillis = getDateFromFormat(ends, g_user_date_time_format);
var minutes = (endMillis - startMillis) / (1000 * 60);
if(minutes > 480) {
alert('An Activity may only last 8 hours. You must enter multiple activities if the time required exceeds 8 hours.');
g_form.setValue('work_end', '');
}
}
Obviously you will need to calculate the a year to then compare for your alert. Thinking out loud an onSubmit may be better because you can prevent the save if it exceeds a year.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-17-2016 08:18 AM
Karen, sorry I have been and still traveling. Yes since you are getting a value of zero that is absolutely the cause of your issue. I would continue to troubleshoot the start and end values.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-31-2016 05:21 AM
Hi Mike here is the script that was used that actually works:
function onChange(control, oldValue, newValue, isLoading, isTemplate) {
if (isLoading || newValue == '') {
return;
}
var starts = g_form. getValue('priv_begin_date');
startMillis = getDateFromFormat(starts, g_user_date_format);
var ends = g_form.getValue('priv_end_date');
endMillis = getDateFromFormat(ends, g_user_date_format);
var minutes = (endMillis - startMillis) / (1000 * 60);
if(minutes > 525600) {
alert('Duration between the begin and end dates cannot exceed 365 Days');
g_form.setValue('priv_end_date', '');
}
}
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-31-2016 09:28 AM
Awesome very happy you got this sorted.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-23-2017 03:28 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-16-2016 09:53 AM
Sorry I am confused here. What is the field you want to validate for field length and only digits?