Script to get the month and year from the "created" field

carlh · ‎06-23-2017

Hi All, I'm looking for a way to create a more simple report showing incidents over time.

The report I want to make requires me to be able to create a pivot table or bar chart where I can group by month and year

The report will conditions will be as follows.

Table = Incident

Column - Custom field "u_month"

Row - Club Name

Created ON Last 12 months

Coul anyone help me with a script to put on the business rule on insert?

I've attached a screen shot of the hopeful result.

Ankur Bawiskar · ‎06-23-2017

Hi Carl,

here is your script which you can add to business rule and accordingly populate the month and year values in whichever field you want:

var nowDateTime = new GlideDateTime(current.sys_created_on);

var date = nowDateTime.getDate();

var month = date.toString().split("-")[1];

var year = date.toString().split("-")[0];

current.u_month = month;

current.u_year = year;

Mark Correct if this solves your issue and also hit Like and Helpful if you find my response worthy based on the impact.

Thanks

Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

carlh · ‎06-23-2017

Thank you Rob! I marked the answer from Ankur as correct since it was a perfect answer to my original post.

BUT! I really appreciate your quick response with the right fix to what I left off!

carlh · ‎06-23-2017

thank you! this did exactly what I asked!

carlh · ‎06-26-2017

Hello again. So I have updated most of my records and after doing so I realize I don't have a way to sort the field in a column. Is there a way to set the order you want?

The result I am getting (as shown below) won't work.

Deepanshi Sood · ‎10-12-2021

Hi @Ankur Bawiskar If I want to fetch the month's name using this above script what should I write?

For example now it is giving the month in number but I want to fetch the name of the month.

Can you help?

perfectpochicha · ‎12-13-2022

Hi there, i was trying to create a script for a rule I need, the rule is to check is a record was created within the last 7 years/ Could you help me with that?