We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

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

paulmorris
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


paulmorris
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