Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Display Week number based on Date in Year

chanikya
Mega Sage

i have 2-field

1.Week number

2.Current number

Display week number based on date

Ex: Jan 1 to Jan 7   Between dates related to Week-1

Jan 8 to jan 14 between dats related to Week 2

Jan 15 to jan 21 bewteen dates related to week 3

now Current date: 2017-01-20       week: week-3;

now Current date:2017-01-14           week: week-2

as like this display week number based on Current date.

1 ACCEPTED SOLUTION

The SN Nerd
Giga Sage
Giga Sage

Use GlideDateTIme.



Example below:



var now = new GlideDateTime();


gs.addInfoMessage(now.getWeekOfYearLocalTime());



49


https://developer.servicenow.com/app.do#!/api_doc?v=jakarta&id=r_ScopedGlideDateTimeGlideDateTime



ServiceNow Nerd
ServiceNow Developer MVP 2020-2022
ServiceNow Community MVP 2019-2022

View solution in original post

3 REPLIES 3

Bryan Tay3
Mega Guru

Hi Chanikya,



hope the following codes helps:



var date = new Date;


var prefixes = ['1', '2', '3', '4', '5'];


gs.print(('Week-'+prefixes[0|date.getDate()/7]));



cheers...:)


Hi Bryan,



i didn't get you ,



find_real_file.png


The SN Nerd
Giga Sage
Giga Sage

Use GlideDateTIme.



Example below:



var now = new GlideDateTime();


gs.addInfoMessage(now.getWeekOfYearLocalTime());



49


https://developer.servicenow.com/app.do#!/api_doc?v=jakarta&id=r_ScopedGlideDateTimeGlideDateTime



ServiceNow Nerd
ServiceNow Developer MVP 2020-2022
ServiceNow Community MVP 2019-2022