Display Week number based on Date in Year

chanikya
Kilo 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