want to add last day of current month and first day of upcoming month in description

[VaibhavM]

I have requirement of raising catalog item request automatically using scheduled job. Other all fields are fixed and I hardcoded it but the issue is in description field

Description- "Bellow are the details to follow

 Stop: 31.07.2025, 5:00 PM EET
Start: 01.08.2025, 6:00 AM EET"

stop should be current months last date...time will be same

start should be upcoming months first date...time will be same

example

if current month is September then description should be

"Bellow are the details to follow

 Stop: 30.09.2025, 5:00 PM EET
Start: 01.10.2025, 6:00 AM EET"

I need to do this in scheduled job script.

screenshot is attached of existing script

[SANDEEP28 · Accepted solution]

@VaibhavM Here is the updated script

var todayDateTime = new GlideDateTime();
todayDateTime.setDayOfMonthUTC(35);
var lastDateCurrentMonth = todayDateTime.getDate();
todayDateTime.addDays(1);
var firstDateNextMonth = todayDateTime.getDate();

var lastDateTimeCurrentMonth = lastDateCurrentMonth + ', 5:00 PM EET';
var firstDateTimeCurrentMonth = firstDateNextMonth + ', 6:00 AM EET';


var description = "Bellow are the details to follow\n" +
                  "Stop:  " + lastDateTimeCurrentMonth + "\n" +
                  "Start:  " + firstDateTimeCurrentMonth;

var cartId = GlideGuid.generate(null);
var cart = new Cart(cartId);
 
// Add the catalog item (qty =1)
var item = cart.addItem('ef28326d1bd2c690257b4bcbfb', 1);

cart.setVariable(item, "requested_for", "381a5ff6db95bd506f39972619f3");
cart.setVariable(item, "user", "381a5ff6db95bd506f399f39619f3");
cart.setVariable(item, "configuration_item", "54ec805e1b50143e0edacd4bcb23");
cart.setVariable(item, "configuration_item", "54ec805e1bb1143e0edacd4bcb23");
cart.setVariable(item, "application_environment", "54ec805e1bb1c05014acd4bcb23");
cart.setVariable(item, "system_name_ci", "88b228f01b2780908e7f4d4bcb9f");
//cart.setVariable(item, "u_environment", "Environment");

cart.setVariable(item, "short_description", "Stopping YOP PREPROC application on one node");
cart.setVariable(item, "description",  description );


var req = cart.placeOrder();
 
// Update RITM
var ritm = new GlideRecord('sc_req_item');
ritm.addQuery('request', req.sys_id);
ritm.query();
if (ritm.next()) {
  ritm.work_notes = "Auto-created for month‑end.";
  ritm.update();
}

  If I could help you with your Query then, please hit the Thumb Icon and mark as Correct !!

[Ankur Bawiskar · Accepted solution]

@VaibhavM 

then this sample script you can use and enhance in your logic

// Helper function to pad zeros
function pad2(n) {
  return n < 10 ? '0' + n : n;
}

// Get current date in JS Date for easy date math
var now = new Date();

// Calculate last day of the current month
var lastDayOfCurrentMonth = new Date(now.getFullYear(), now.getMonth() + 1, 0); 
// Explanation: Passing day=0 returns last day of previous month (here: next month zero-th day = last day of current month)

// Calculate first day of next month
var firstDayOfNextMonth = new Date(now.getFullYear(), now.getMonth() + 1, 1);

// Format to your required format: DD.MM.YYYY
// Your example uses day.month.year - but your example text shows "31.07.2025", so:
// Format: DD.MM.YYYY for clarity
function formatDate(d) {
  return pad2(d.getDate()) + "." + pad2(d.getMonth() + 1) + "." + d.getFullYear();
}

var stopDateString = formatDate(lastDayOfCurrentMonth);
var startDateString = formatDate(firstDayOfNextMonth);

// Compose description
var description = "Bellow are the details to follow\n" +
    "Stop: " + stopDateString + ", 5:00 PM EET\n" +
    "Start: " + startDateString + ", 6:00 AM EET";

gs.info(description);

// Use the 'description' variable to set your catalog item field

Output:

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@VaibhavM 

this is a simpler one

function pad2(n) {
  return n < 10 ? '0' + n : n;
}

var now = new Date();

// Last day of current month
var lastDay = new Date(now.getFullYear(), now.getMonth() + 1, 0);

// First day of next month
var firstDayNextMonth = new Date(now.getFullYear(), now.getMonth() + 1, 1);

var stopDate = pad2(lastDay.getDate()) + "." + pad2(lastDay.getMonth() + 1) + "." + lastDay.getFullYear();
var startDate = pad2(firstDayNextMonth.getDate()) + "." + pad2(firstDayNextMonth.getMonth() + 1) + "." + firstDayNextMonth.getFullYear();

var description = "Bellow are the details to follow\n" +
                  "Stop: " + stopDate + ", 5:00 PM EET\n" +
                  "Start: " + startDate + ", 6:00 AM EET";

gs.info(description);

// Now you can set 'description' to your catalog item request's description field

Output:

If my response helped please mark it correct and close the thread so that it benefits future readers.

[SANDEEP28]

@VaibhavM You can use below  script to set the value in description field. First run in BG script to verify the output

var todayDateTime = new GlideDateTime();
todayDateTime.setDayOfMonthUTC(35);

var lastDateCurrentMonth = todayDateTime.getDate();
gs.info(lastDateCurrentMonth);

todayDateTime.addDays(1);
var firstDateNextMonth = todayDateTime.getDate();
gs.info(firstDateNextMonth);

var lastDateTimeCurrentMonth = lastDateCurrentMonth + ', 5:00 PM EET';
var firstDateTimeCurrentMonth = firstDateNextMonth + ', 6:00 AM EET';

gs.info(lastDateTimeCurrentMonth);
gs.info(firstDateTimeCurrentMonth);

var description = "Bellow are the details to follow\n" +
                  "Stop:  " + lastDateTimeCurrentMonth + "\n" +
                  "Start:  " + firstDateTimeCurrentMonth;

gs.info(description);  //this description variable you can map to record description field

  If I could help you with your Query then, please hit the Thumb Icon and mark as Correct !!

[SANDEEP28 · Accepted solution]

@VaibhavM Here is the updated script

var todayDateTime = new GlideDateTime();
todayDateTime.setDayOfMonthUTC(35);
var lastDateCurrentMonth = todayDateTime.getDate();
todayDateTime.addDays(1);
var firstDateNextMonth = todayDateTime.getDate();

var lastDateTimeCurrentMonth = lastDateCurrentMonth + ', 5:00 PM EET';
var firstDateTimeCurrentMonth = firstDateNextMonth + ', 6:00 AM EET';


var description = "Bellow are the details to follow\n" +
                  "Stop:  " + lastDateTimeCurrentMonth + "\n" +
                  "Start:  " + firstDateTimeCurrentMonth;

var cartId = GlideGuid.generate(null);
var cart = new Cart(cartId);
 
// Add the catalog item (qty =1)
var item = cart.addItem('ef28326d1bd2c690257b4bcbfb', 1);

cart.setVariable(item, "requested_for", "381a5ff6db95bd506f39972619f3");
cart.setVariable(item, "user", "381a5ff6db95bd506f399f39619f3");
cart.setVariable(item, "configuration_item", "54ec805e1b50143e0edacd4bcb23");
cart.setVariable(item, "configuration_item", "54ec805e1bb1143e0edacd4bcb23");
cart.setVariable(item, "application_environment", "54ec805e1bb1c05014acd4bcb23");
cart.setVariable(item, "system_name_ci", "88b228f01b2780908e7f4d4bcb9f");
//cart.setVariable(item, "u_environment", "Environment");

cart.setVariable(item, "short_description", "Stopping YOP PREPROC application on one node");
cart.setVariable(item, "description",  description );


var req = cart.placeOrder();
 
// Update RITM
var ritm = new GlideRecord('sc_req_item');
ritm.addQuery('request', req.sys_id);
ritm.query();
if (ritm.next()) {
  ritm.work_notes = "Auto-created for month‑end.";
  ritm.update();
}

  If I could help you with your Query then, please hit the Thumb Icon and mark as Correct !!

[VaibhavM]

Thanks @SANDEEP28 & @Ankur Bawiskar  for your valuable time, Tried with both solutions and its working as expected.