Display Quarter number based on date in Year

chanikya · ‎12-07-2017

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

Harsh Vardhan · ‎12-08-2017

remove current.update()

var check= current.u_another_open;

var test = new GlideDateTime(check);

var mn = test.getMonth();

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

gs.log('hellosssssss'+quar);

current.u_dateee=quar;

divya mishra · ‎12-07-2017

Hey Chanikya,

Try using the below script to get the month :

var gdt = new GlideDateTime();

gs.print(gdt.getMonth());

Once you get the values of month you can easily set the 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

Kannan Nadar · ‎12-07-2017

Hi,

You can try something like below.

var gdt = new GlideDateTime(current.my_date);

var month = gdt.getMonth();

var quarter = Math.ceil(month/3);

gs.print(quarter);

chanikya · ‎12-07-2017

Hi Kannan,

there are showing Quarter value 1.0 it should display only 1

Script is :

var gdt = new GlideDateTime(current.u_current_date);

var month = gdt.getMonth();

current.u_quater = Math.ceil(month/3);

current.update();

Kannan Nadar · ‎12-07-2017

What is the field type of quarter?