Welcome to Community Week 2025! Join us to learn, connect, and be recognized as we celebrate the spirit of Community and the power of AI. Get the details  

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

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

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