Display Quarter number based on date in Year

[chanikya]

1.Quarter number

2.Current number

Display Quarter number based on date

Ex: Jan   to march   Between related dates Display Quarter -1

April to June Between related dates Display Quarter -3 etc.

Ex:

now Current date: 2017-01-20       week: Quarter-1;

now Current date:2017-05-14           week: Quarter-2

[divya mishra]

Thanks Brian,

I have shared the completed script in the trails below and thats working perfectly

[chanikya]

Hi Brian,

Script is :

var gdt = new GlideDateTime(current.u_current_date);

current.u_quater = "Quarter::" + parseInt(gdt.getMonthLocalTime()/3);

gs.addInfoMessage("Quarter::" + parseInt(gdt.getMonthLocalTime()/3));

current.update();

result is comming like this

[chanikya]

Hi Divya,

how can we display Quarter value in Quarter field.

[divya mishra]

Hi Chanikya,

If doing via BR:

var gdt = new GlideDateTime();

var month = gdt.getMonth();

var quarter;

gs.print(month);

if((month==1) ||(month==2) ||(month==3) ||(month==4)){

quarter=1;

gs.print("Quarter::"+quarter);

}

else if((month==5) ||(month==6) ||(month==7) ||(month==8)){

quarter=2;

gs.print("Quarter::"+quarter);

}

else{

quarter=3;

gs.print("Quarter::"+quarter);

}

or if you are doin it via client script g_form.setValue("fieldname",quarter);

post me your feedback

Please Hit ✅Correct, ��Helpful, or ��Like depending on the impact of the response

Have a lovely day ahead

Regards,

Divya Mishra

[divya mishra]

var gdt = new GlideDateTime();

var month = gdt.getMonth();

var quarter;

if((month==1) ||(month==2) ||(month==3) ||(month==4)){

current.u_qua=1;

current.update();

}

else if((month==5) ||(month==6) ||(month==7) ||(month==8)){

current.u_qua=2;

current.update();

}

else{

current.u_qua=3;

current.update();

}

Try this....