We've updated the ServiceNow Community Code of Conduct, adding guidelines around AI usage, professionalism, and content violations. Read more

How to get Last friday date

Afrin12
Tera Contributor

Hi,
How to get Last friday date through script include

2 ACCEPTED SOLUTIONS

Mike_R
Kilo Patron

This script should work. You can try it in a background script

 

 

var gdt = new GlideDateTime();
var today = gdt.getDayOfWeekUTC();


if(today == 1){ //today is monday
gdt.addDaysUTC(-3);
}

else if(today == 2){ //today is tues
gdt.addDaysUTC(-4);
}

else if(today == 3){ //today is wed
gdt.addDaysUTC(-5);
}

else if(today == 4){ //today is thurs
gdt.addDaysUTC(-6);
}

else if(today == 5){ //today is fri
gdt.addDaysUTC(-7);
}

else if(today == 6){//today is sat
gdt.addDaysUTC(-1);
}
else if(today == 7){//today is sun
gdt.addDaysUTC(-2);
} 



gs.info(gdt.getDate());

 

View solution in original post

Saurabh Gupta
Kilo Patron

Hi, 

 

var dt=new GlideDateTime()
var dayow=dt.getDayOfWeekUTC();
var ad;
if(dayow<5)
ad=-(dayow+2)
else if(dayow>5)
ad=5-dayow;
else
ad=-7;

dt.addDaysUTC(ad)
gs.info("Last Friday is on: "+dt)

Thanks and Regards,

Saurabh Gupta

View solution in original post

2 REPLIES 2

Mike_R
Kilo Patron

This script should work. You can try it in a background script

 

 

var gdt = new GlideDateTime();
var today = gdt.getDayOfWeekUTC();


if(today == 1){ //today is monday
gdt.addDaysUTC(-3);
}

else if(today == 2){ //today is tues
gdt.addDaysUTC(-4);
}

else if(today == 3){ //today is wed
gdt.addDaysUTC(-5);
}

else if(today == 4){ //today is thurs
gdt.addDaysUTC(-6);
}

else if(today == 5){ //today is fri
gdt.addDaysUTC(-7);
}

else if(today == 6){//today is sat
gdt.addDaysUTC(-1);
}
else if(today == 7){//today is sun
gdt.addDaysUTC(-2);
} 



gs.info(gdt.getDate());

 

Saurabh Gupta
Kilo Patron

Hi, 

 

var dt=new GlideDateTime()
var dayow=dt.getDayOfWeekUTC();
var ad;
if(dayow<5)
ad=-(dayow+2)
else if(dayow>5)
ad=5-dayow;
else
ad=-7;

dt.addDaysUTC(ad)
gs.info("Last Friday is on: "+dt)

Thanks and Regards,

Saurabh Gupta