question Set date to specific time in Developer forum

Set date to specific time

samuelscott — Mon, 11 Sep 2017 22:41:08 GMT

Hello,

I'm trying to automatically set a due date field to whatever day is chosen but I want the time to ALWAYS be at 11:59 pm (last hour of due date). The code I'm using is placed on a task box inside a workflow. The result I'm getting is not what I'm looking for. Does anybody know if this code is the problem?

//current.comments = "Due date proposed: " + current.variables.due_date;   var dateDueDate = due_date.toString()+ ' 23:59:59';     var dueDate = new GlideDateTime(dateDueDate);     var dayOfWeek = parseInt(dueDate.getDayOfWeekLocalTime());     dueDate.setDisplayValue(dateDueDate, "yyyy-MM-dd HH:mm:ss"); dateString = "dd/mm/yyyy";     current.due_date = current.variables.due_date; var gdt = current.due_date.getGlideObject(); gdt.addDaysUTC(1);

Re: Set date to specific time

EdwinCoronado — Mon, 11 Sep 2017 22:46:17 GMT

If your date field is a Date and Time type of field, it will store the time in UTC time zone. You can do something like:

var dateTimeObj = new GlideDateTime(current.your_date_field); 

var myDate = dateTimeObj.getLocalDate() + " 23:59:59");

Re: Set date to specific time

Shishir Srivast — Tue, 12 Sep 2017 02:22:36 GMT

Please check if this helps.

current.dueDate = current.dueDate.toString().split(' ')[0]+ ' ' +'23:59:59';

Re: Set date to specific time

lakshminarayan4 — Tue, 12 Sep 2017 03:17:31 GMT

Hi,

Please use this snippet.

var format = gs.getUser().getDateTimeFormat() + "";

var result = "";

if(format.indexOf('h') < 0 && format.indexOf('a') < 0)

result = "Due date proposed: " + current.variables.due_date + "11:59";

else

result = "Due date proposed: " + current.variables.due_date + "23:59";

Thanks

- YLN

Re: Set date to specific time

samuelscott — Tue, 12 Sep 2017 15:10:15 GMT

Hi Edwin,

But where are you setting the due_date field to the new value? And in your code, aren't you dealing with a date/time format all the time and end up adding the " 23:59:59" at the end?

When adding you recommended code as shown below,

//current.comments = "Due date proposed: " + current.variables.due_date;



/*var dateDueDate = due_date.toString()+ ' 23:59:59';

   var dueDate = new GlideDateTime(dateDueDate);

   var dayOfWeek = parseInt(dueDate.getDayOfWeekLocalTime());

   dueDate.setDisplayValue(dateDueDate, "yyyy-MM-dd HH:mm:ss");

dateString = "dd/mm/yyyy";

*/

var dateTimeObj = new GlideDateTime(current.due_date);     

var myDate = dateTimeObj.getLocalDate() + " 23:59:59";



current.due_date = current.variables.due_date;

var gdt = current.due_date.getGlideObject();

gdt.addDaysUTC(1);

I get the following result on the targeted field:

It seems as if it is adding the actual string value as an integer rather than concatenating the string

Re: Set date to specific time

samuelscott — Tue, 12 Sep 2017 15:47:31 GMT

Hi Shishir,

When placing your code as shown below, i get the following result.

//current.comments = "Due date proposed: " + current.variables.due_date;



/*var dateDueDate = due_date.toString()+ ' 23:59:59';

   var dueDate = new GlideDateTime(dateDueDate);

   var dayOfWeek = parseInt(dueDate.getDayOfWeekLocalTime());

   dueDate.setDisplayValue(dateDueDate, "yyyy-MM-dd HH:mm:ss");

dateString = "dd/mm/yyyy";

*/



current.dueDate = current.dueDate.toString().split(' ')[0]+ ' ' +'23:59:59';



current.due_date = current.variables.due_date;

var gdt = current.due_date.getGlideObject();

gdt.addDaysUTC(1);

Re: Set date to specific time

Shishir Srivast — Tue, 12 Sep 2017 16:09:52 GMT

can you please just have this line and test,

current.variables.dueDate = current.variables.dueDate.toString().split(' ')[0]+ ' ' +'23:59:59';

are you trying to add 1 day in due date? if this is the case the i think, you can try in this way.

var dateDueDate = current.variables.dueDate;

var dueDate = new GlideDateTime(dateDueDate);

dueDate.addDaysUTC(1);

current.variables.dueDate = dueDate.setDisplayValue.split(' ')[0]+ ' ' +'23:59:59';

Re: Set date to specific time

samuelscott — Tue, 12 Sep 2017 17:04:14 GMT

but where is the variable dueDate coming from? it doesn't exist in my form....

i tried this, but it didn't do the trick:

current.due_date = new GlideDateTime(current.due_date.toString().split(' ')[0]+ ' 23:59:59');

var gdt = current.due_date.getGlideObject();

gdt.addDaysUTC(1);

i think what you meant was:

var dateDueDate = current.due_date;

var dueDate = new GlideDateTime(dateDueDate);

due_date.addDaysUTC(1);

current.due_date = due_date.setDisplayValue.split(' ')[0]+ ' ' +'23:59:59';

and yes....I'm trying to add 1 day, and that part is actually working

Re: Set date to specific time

samuelscott — Tue, 12 Sep 2017 21:46:10 GMT

this is the correct answer:

var dateDueDate = current.due_date;

var dueDate = new GlideDateTime(dateDueDate);

var arrDate = [];

arrDate = dueDate.toString().split(' ');

current.due_date.setDisplayValue(arrDate[0]+ ' 23:59:59','yyyy-MM-dd HH:mm:ss');

Re: Set date to specific time

MG Casey — Sun, 14 Jun 2020 13:23:44 GMT

Seems weird there's no other way to do this without parsing strings.

Re: Set date to specific time

User342536 — Tue, 15 Dec 2020 02:20:06 GMT

This worked fine!!!

In my case, original date field was in blank, and I needed to set it up with a new and fixed date.

Thx

Re: Set date to specific time

MG Casey — Tue, 15 Dec 2020 13:46:38 GMT

This will not work if the user has selected a different display format for dates in ServiceNow (which is uncommon, but could be around 5-10% of your userbase).

I'd recommend this:

var dueDate = new GlideDateTime(current.getValue("due_date"));
var dueDateMidnight = new GlideDateTime();
dueDateMidnight.setDisplayValueInternal(String(dueDate.getLocalDate()) + " 23:59:59");

current.setValue("due_date", dueDateMidnight.getValue());

Re: Set date to specific time

Eric Medina — Tue, 04 May 2021 20:12:01 GMT

I recently had this issue and came up with the following solution which only uses documented methods and a minimal amount of string spaghetti:

function setTime(oldDate, time) {
  var newDate = new GlideDateTime('1970-01-01 ' + time);
  if (!newDate.isValid()) {
    throw new Error('Invalid time provided: ' + time);
  }
  newDate.setYearUTC(oldDate.getYearUTC());
  newDate.setMonthUTC(oldDate.getMonthUTC());
  newDate.setDayOfMonthUTC(oldDate.getDayOfMonthUTC());
  return newDate;
}

You can use it like this:

var todayAtNoon = setTime(new GlideDateTime(), '12:00:00');

which would get you a GlideDateTime representing today at noon.

Re: Set date to specific time

Tim Grindlay — Wed, 30 Mar 2022 09:38:56 GMT

Old post new script. This one preserves the locality of the time as often we want a local representation of time so it's consistent when comparing with other objects in the system.

var myDateTimeField = ; //Set variable to the date/time field you want to change
var time = ; //Set the time as a string, i.e. "12:30:00"

var newDateTime = setTime(myDateTimeField, time); 
var localDateTime = newDateTime.getDisplayValue();

function setTime(DateTime, time) {

        //Convert to GlideDateTime
        var oldDateTime = new GlideDateTime(DateTime); 

        var gtime1 = new GlideTime();
        gtime1.setValue(time);

        var newDateTime = new GlideDateTime();

        //Preserves the date in local time but sets the time portion to 00:00:00
        newDateTime.setDisplayValue(oldDateTime.getLocalDate());

        //Add the time portion on
        newDateTime.add(gtime1);

        return newDateTime;
    }