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
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
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
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
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