question Re: Need to Get the day based on entered date & time in Developer forum

Need to Get the day based on entered date & time

is_12 — Thu, 23 Oct 2025 06:46:37 GMT

Hi Community,

On the Catalog form I have field start & end date.

Based on the start date need to get the day

And also based on the start date, need to get the next 3months & 6months & 12months date

Can anyone help me with this

Thanks,

Re: Need to Get the day based on entered date & time

Ankur Bawiskar — Thu, 23 Oct 2025 06:58:49 GMT

@is_12

something like this in client script will help you

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

Re: Need to Get the day based on entered date & time

miftikhar20 — Thu, 23 Oct 2025 07:45:03 GMT

@is_12 , Add below code in your on change script on start date field.

function onChange(control, oldValue, newValue, isLoading) { if (isLoading || !newValue) return; var startDate = new Date(newValue); var days = ['Sunday', 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday']; var dayName = days[startDate.getDay()]; function addMonths(date, months) { var d = new Date(date); d.setMonth(d.getMonth() + months); return ( d.getFullYear() + '-' + String(d.getMonth() + 1).padStart(2, '0') + '-' + String(d.getDate()).padStart(2, '0') ); } var next3 = addMonths(startDate, 3); var next6 = addMonths(startDate, 6); var next12 = addMonths(startDate, 12); g_form.setValue('u_day_name', dayName); g_form.setValue('u_3_months_date', next3); g_form.setValue('u_6_months_date', next6); g_form.setValue('u_12_months_date', next12); }

Re: Need to Get the day based on entered date & time

Simon Christens — Thu, 23 Oct 2025 08:10:06 GMT

Hi @Ankur Bawiskar & @miftikhar20

Could you please refactor the code to support all the different date formats that ServiceNow provides as each user could change their date / time formats and if its not the OOB yyyy-MM-dd format then both the scripts will break as new Date() expects a specific format

Re: Need to Get the day based on entered date & time

svirkar420 — Thu, 23 Oct 2025 08:36:52 GMT

Hi there @is_12 , Here is the script it should work for all date and time formats regardless of any region.

Script -

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

var gdt = new GlideDateTime();
gdt.setDisplayValue(newValue);

var dayOfWeek = getDayName(gdt);

var date3 = new GlideDateTime(gdt);
date3.addMonthsLocalTime(3);

var date6 = new GlideDateTime(gdt);
date6.addMonthsLocalTime(6);

var date12 = new GlideDateTime(gdt);
date12.addMonthsLocalTime(12);

g_form.setValue('day_of_week', dayOfWeek);
g_form.setValue('next_3_months', date3.getDisplayValue());
g_form.setValue('next_6_months', date6.getDisplayValue());
g_form.setValue('next_12_months', date12.getDisplayValue());
}

function getDayName(gdt) {
var jsDate = new Date(gdt.getNumericValue());
var days = ['Sunday', 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday'];
return days[jsDate.getDay()];
}

If this answer helps you in any way make sure to Mark this as accepted solution and give a thumbs up this will also benefit others as well.
Regards.
Saurabh V.

Re: Need to Get the day based on entered date & time

svirkar420 — Thu, 23 Oct 2025 08:36:16 GMT

Hi @Simon Christens , Try this code this should work for all regions and time formats.

Script:

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

var gdt = new GlideDateTime();
gdt.setDisplayValue(newValue);

var dayOfWeek = getDayName(gdt);

var date3 = new GlideDateTime(gdt);
date3.addMonthsLocalTime(3);

var date6 = new GlideDateTime(gdt);
date6.addMonthsLocalTime(6);

var date12 = new GlideDateTime(gdt);
date12.addMonthsLocalTime(12);

function getDayName(gdt) {
var jsDate = new Date(gdt.getNumericValue());
var days = ['Sunday', 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday'];
return days[jsDate.getDay()];
}

If this answer helps you in any way make sure to Mark this as accepted solution and give a thumbs up this will also benefit others as well.
Regards.
Saurabh V.

Re: Need to Get the day based on entered date & time

Ankur Bawiskar — Fri, 24 Oct 2025 07:36:54 GMT

@is_12

try this and it will take care of any date/time format

function onChange(control, oldValue, newValue, isLoading) { if (isLoading || newValue == '') { return; } // Parse string to milliseconds var dateMS = getDateFromFormat(newValue, g_user_date_time_format); var newDT = new Date(); newDT.setTime(dateMS); // Example: Add 3 months newDT.setMonth(newDT.getMonth() + 3); // If you want 6 or 12 months, just change the +3: // newDT.setMonth(newDT.getMonth() + 6); // For 6 months // newDT.setMonth(newDT.getMonth() + 12); // For 12 months var val = formatDate(newDT, g_user_date_time_format); alert(val); }

Output:I added 3 months, enhance further

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

Re: Need to Get the day based on entered date & time

Ankur Bawiskar — Thu, 23 Oct 2025 09:06:40 GMT

@svirkar420

are you sure the above script will work fine in client script?

Could you please share a working example?

Re: Need to Get the day based on entered date & time

Ankur Bawiskar — Fri, 24 Oct 2025 03:32:01 GMT

@is_12

Hope you are doing good.

Did my reply answer your question?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

Re: Need to Get the day based on entered date & time

is_12 — Fri, 24 Oct 2025 07:23:09 GMT

@Ankur Bawiskar @miftikhar20

I have tried to implement the based on the start date, need to get the next 3months & 6months & 12months date, but both of the code, which you guy's have given is getting the console javascript error on the portal.

function addMonths(date, months) {

alert('Hello7');

var d = new Date(date);

d.setMonth(d.getMonth() + months);

return (

d.getFullYear() +

'-' +

String(d.getMonth() + 1).padStart(2, '0') +

'-' +

String(d.getDate()).padStart(2, '0')

);

}

var next3 = addMonths(startDate, 3);

var next6 = addMonths(startDate, 6);

var next12 = addMonths(startDate, 12);

//g_form.setValue('u_day_name', dayName);

g_form.setValue('day_3', next3);

alert('Hello22'+next3);

g_form.setValue('day_6', next6);

alert('Hello24'+next6);

g_form.setValue('day_12', next12);

alert('Hello26'+next12);

only first alert I'm getting post that I'm getting the error

Re: Need to Get the day based on entered date & time

Ankur Bawiskar — Fri, 24 Oct 2025 07:37:42 GMT

@is_12

I gave another easy code below with output.

Did you check that?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

Re: Need to Get the day based on entered date & time

is_12 — Fri, 24 Oct 2025 07:41:31 GMT

@Ankur Bawiskar

yes I have tried but it is getting set to today's date only

Re: Need to Get the day based on entered date & time

is_12 — Fri, 24 Oct 2025 07:43:05 GMT

@Ankur Bawiskar But instead I need 3months or 6months date from today

Re: Need to Get the day based on entered date & time

Ankur Bawiskar — Fri, 24 Oct 2025 07:44:39 GMT

@is_12

I just now updated the script, are you using the correct one?

share your client script and is it marked as UI Type - ALL

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

Re: Need to Get the day based on entered date & time

MaxMixali — Fri, 24 Oct 2025 08:06:33 GMT

ServiceNow – Catalog item: derive Day of Week and +3/+6/+12 month dates from Start Date

What you want
- On a catalog form, when the user selects Start Date:
1) Show the Day of Week for that date
2) Auto-populate dates at +3 months, +6 months, and +12 months

Approach (robust & timezone-safe)
Use an onChange Catalog Client Script that calls a Client‑callable Script Include. The server computes dates with GlideDateTime (handles locale/DST correctly), and returns a small JSON payload for the client to set variables.

Variables (example names)
- start_date (Type: Date)
- day_of_week (Type: Single Line Text, Read‑only = true)
- date_plus_3m (Type: Date, Read‑only = true)
- date_plus_6m (Type: Date, Read‑only = true)
- date_plus_12m (Type: Date, Read‑only = true)

1) Script Include (Client callable)
----------------------------------
Name: DateCalcAjax (global or your scope)
Client callable: ✔

/** Script Include **/
var DateCalcAjax = Class.create();
DateCalcAjax.prototype = Object.extendsObject(AbstractAjaxProcessor, {
getOffsets: function() {
var start = this.getParameter('sysparm_start'); // expects display or ISO date (yyyy-MM-dd)
if (!start) return '{}';

// Initialize
var gdt = new GlideDateTime();
// If start is just a date (no time), set to local 00:00
gdt.setDisplayValue(start + ' 00:00:00');

// Day of week (1=Sunday .. 7=Saturday for getDayOfWeekLocalTime())
var dowNum = gdt.getDayOfWeekLocalTime ? gdt.getDayOfWeekLocalTime() : gdt.getDayOfWeek(); // fallback
var names = ['Sunday','Monday','Tuesday','Wednesday','Thursday','Friday','Saturday'];
// Map 1..7 → 0..6
var dowName = names[(dowNum - 1 + 7) % 7];

function addMonthsClone(srcGdt, n) {
var copy = new GlideDateTime(srcGdt);
copy.addMonthsLocalTime(n);
return copy.getDate().getValue(); // yyyy-MM-dd
}

var d3 = addMonthsClone(gdt, 3);
var d6 = addMonthsClone(gdt, 6);
var d12 = addMonthsClone(gdt, 12);

var payload = {
day_of_week: dowName,
date_plus_3m: d3,
date_plus_6m: d6,
date_plus_12m: d12
};
return new global.JSON().encode(payload);
},

type: 'DateCalcAjax'
});

2) Catalog Client Script (onChange on start_date)
-------------------------------------------------
Type: onChange
Applies to: Catalog Client Script
UI Type: All (Desktop, Mobile, Service Portal)
Variable name: start_date
Script:
function onChange(control, oldValue, newValue, isLoading, isTemplate) {
if (isLoading) return;
if (!newValue) {
g_form.clearValue('day_of_week');
g_form.clearValue('date_plus_3m');
g_form.clearValue('date_plus_6m');
g_form.clearValue('date_plus_12m');
return;
}

Notes & Tips
------------
- Ensure your variable names in the script (day_of_week, date_plus_3m, etc.) match the actual variable “Name” (not the label).
- Date variable values should be in yyyy-MM-dd format; the Script Include already returns that.
- If you also need to set an End Date, add logic in the Script Include to compute it and add to payload.
- This works in Classic UI, Service Portal, and Workspace.
- If you prefer a pure client approach (no server call), you can compute with JavaScript Date(), but you must handle timezones and month-end rollovers yourself. Example snippet below.

Pure client (optional alternative)
----------------------------------
function addMonthsYMD(ymd, months) {
// ymd: 'yyyy-MM-dd'
var parts = ymd.split('-');
var y = parseInt(parts[0],10), m = parseInt(parts[1],10)-1, d = parseInt(parts[2],10);
var dt = new Date(Date.UTC(y, m, d));
dt.setUTCMonth(dt.getUTCMonth() + months);
var yyyy = dt.getUTCFullYear();
var mm = String(dt.getUTCMonth()+1).padStart(2,'0');
var dd = String(dt.getUTCDate()).padStart(2,'0');
return yyyy + '-' + mm + '-' + dd;
}

function dayOfWeekName(ymd) {
var p = ymd.split('-');
var dt = new Date(Date.UTC(+p[0], +p[1]-1, +p[2]));
return ['Sunday','Monday','Tuesday','Wednesday','Thursday','Friday','Saturday'][dt.getUTCDay()];
}

Re: Need to Get the day based on entered date & time

is_12 — Fri, 24 Oct 2025 12:26:11 GMT

@Ankur Bawiskar, Thanks for your solution,

There is a small change instead of start date + 3months, based on selected "start date" we have day of month that is nothing but date based on that it should be +3 or +6

Below is the reference

Tried with this below script

Client script

var dateMS = getDateFromFormat(newValue, g_user_date_time_format);

var newDT = new Date();

newDT.setTime(dateMS);

//alert("8"+dateMS);

// Example: Add 3 months

var ga = new GlideAjax('BT_CSR_SSR_CatalogUtils');

ga.addParam('sysparm_name', 'calDate');

ga.addParam('sysparm_date', g_form.getValue('start_date'));

ga.addParam('sysparm_dayofmonth',g_form.getValue('run_dayofmonth'));

ga.getXML(check);

function check(response) {

var answer = response.responseXML.documentElement.getAttribute("answer");

alert("22"+answer);

var ansParsed = JSON.parse(answer);

var gg = g_form.setValue('day_1', ansParsed);

}

var monthly = g_form.getValue('select_month');

if (monthly == 'Every Month') {

alert("12");

newDT.setMonth(newDT.getMonth() + 1);

var val = formatDate(newDT, g_user_date_time_format);

g_form.setValue('day_1', val);

alert("Monthly" + val);

}

script include

calDate: function() {

var sdt = new GlideDateTime(this.getParameter('sysparm_date'));

sdt.addDaysLocalTime(this.getParameter('sysparm_dayofmonth'));

return sdt.getDate();

but getting javascript error

Thanks,

Re: Need to Get the day based on entered date & time

Ankur Bawiskar — Fri, 24 Oct 2025 12:40:45 GMT

@is_12

didn't get the requirement.

you need to add the value 21 (value in earlier variable) to the date entered by user?

Re: Need to Get the day based on entered date & time

is_12 — Fri, 24 Oct 2025 18:55:36 GMT

@Ankur Bawiskar

Let me explain you
Let say user has selected the start date as today(25th) & day of the month as 28(28 is nothing but date) & select month as Every month
then day1 should be from day of month ie 28th +1 rather than start date+1
similarly let say select month is quatarely then it should be 28th +3

Thanks

Re: Need to Get the day based on entered date & time

is_12 — Fri, 07 Nov 2025 11:20:01 GMT

Hi @Ankur Bawiskar,

For Yearly, if it is leap year,then it should be +366 else 365

How, can I achieve it ?

Re: Need to Get the day based on entered date & time

Ankur Bawiskar — Fri, 07 Nov 2025 12:06:12 GMT

@is_12

I think you can enhance the logic for this.

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏