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

Display Quarter number in Quarter field depend on Date

Kishore8
Kilo Guru

My script is not working

var gDate = new GlideDate(current.u_date);

Current.u_quarter= 'Q' + (Math.floor((gDate.getMonth() - 1) / 3) + 1) ;

1 ACCEPTED SOLUTION

Hi,




I have done some modification in script , it is working now


Script :



var gDate = new GlideDate();


gDate.setValue(current.u_date);


current.u_quarter= 'Q' + (Math.floor((gDate.getMonthLocalTime() - 1) / 3) + 1) ;


View solution in original post

6 REPLIES 6

Gowrisankar Sat
Tera Guru

Hi Kishore,



Can you try below code:



var gDate = new GlideDate();


gDate.setValue(current.u_date.getDisplayValue());


current.u_quarter= 'Q' + (Math.floor((gDate.getMonth() - 1) / 3) + 1) ;


Hi Gowrish




not working, please


var test = new GlideDateTime(check);


var mn = test.getMonth();


var quar = Math.ceil(mn/3);


current.u_quarter= 'Q'+quar;


var test = new GlideDateTime(current.u_date);


var mn = test.getMonth();


var quar = Math.ceil(mn/3);


current.u_quarter= 'Q'+quar;