How can we convert todays date to a workday

[JPSS]

I need to convert todays date to a workday. example 5th februvary is the 3rd workday of that month

[Dr Atul G- LNG]

Hi @JPSS 

OOTB not available and to do this, need to read the calendar and then calculate. 

[JPSS]

Can  you please help me with the script

[BalaG]

Hi @JPSS   here is javascript function that can do that.

(function numberOfWorkdays() {
var gdt = new GlideDateTime();
var oneday = 24 * 60 * 60 * 1000;

// get current month
var cmon = gdt.getMonthLocalTime();
var mon = cmon;
var wdays = 0;

while ( mon === cmon ) {

    var dofw = gdt.getDayOfWeekLocalTime();
    if( dofw >= 1 && dofw <= 5) wdays++;
    gdt.subtract(oneday);
    mon = gdt.getMonthLocalTime();
}
return wdays;
}())

If this answer solved your issue please mark it ✅ as a solution or mark it 👍 helpful if it was of help.

--

Bala Guthy

[JPSS]

Hi Bala,

 the date would varies. the function should convert todays date to workday