Get day of the week from date field

[JJG]

I have a date field on a record, I would like to pull the date and get the day of the week from it. Heres what I have so far:

var grDay= new GlideRecord('x_utsll_time_manag_hour_tracker');
grDay.query();
while (grDay.next()) {
     var testdate = grDay.date;
     var dy = testdate.getDayofWeekLocalTime();
     gs.info('Day:'+dy);
     }

Doesn't seem to work, getting an error in the log

[Dhruv Gupta1]

You need to create aglidedatetime object.

getDayOfWeek()

Retrieves the day of the week stored by the GlideDateTime object, expressed in the user's time zone.

Use getDayOfWeekLocalTime() and getDayOfWeekUTC() instead of this method.

Return:

Type	Description
Number	The day of the week value - Monday = 1, ... Sunday = 7.

Example

var gdt = new GlideDateTime("2011-12-01 12:00:00");
gs.print(gdt.getDayOfWeek());

Output

4

getDayOfWeekLocalTime()

Gets the day of the week stored by the GlideDateTime object, expressed in the user's time zone.

Return:

Type	Description
Number	The day of the week value - Monday = 1, ... Sunday = 7

[Mike Patel · Accepted solution]

try

var grDay= new GlideRecord('x_utsll_time_manag_hour_tracker');
grDay.query();
while (grDay.next()) {
	var gdt = new GlideDateTime(grDay.date + ' 12:00:00');
	var dy = gdt.getDayofWeekLocalTime();
	gs.info('Day:'+dy);
}

[Jaspal Singh]

Hi,

Can you try using  var dy = testdate.getDay(); instead of var dy = testdate.getDayofWeekLocalTime();

[JJG]

Got This error

Warning

org.mozilla.javascript.EcmaError: Cannot find function getDay in object 2020-04-16. Caused by error in <refname> at line 104 101: grDay.query(); 102: while (grDay.next()) { 103: var testdate = grDay.date; ==> 104: var dy = testdate.getDay(); 105: gs.info('Day:' + dy); 106: }