349
Views
5
Comments
Solved
[Date time Utils] Current week number
date-time-utils
Reactive icon
Forge asset by João Marques
Application Type
Reactive
Service Studio Version
11.53.43 (Build 62091)

I am trying to get week number for today

As of today, the CurrDate() return is 2023-03-15 

But this function Week_GetWeekDayByDate(CurrDate()) is returning 3

What is the correct input for today's date?


2020-01-08 08-43-00
Rahul Kumar
Solution

Hi Jonathan,

CurrDate() is correct input for today. 

 Week_GetWeekNumberByDate( 0, CurrDate())  can be used to get the week number. 

0 is basically for sunday and 6 will be Saturday. First input of function is basically first day of week.


Cheers

2024-03-22 09-17-23
Chandra Vikas Sharma

Hi ,

 you need to use Week_GetWeekNumberByDate() function for Get week number given date .


2025-04-30 07-30-15
Sanjay Bankar
2020-01-08 08-43-00
Rahul Kumar
Solution

Hi Jonathan,

CurrDate() is correct input for today. 

 Week_GetWeekNumberByDate( 0, CurrDate())  can be used to get the week number. 

0 is basically for sunday and 6 will be Saturday. First input of function is basically first day of week.


Cheers

2025-10-18 11-13-53
Ramesh subramanian

Hi Jonathan Chan,

 Return value 0 for Sunday to 6 for Saturday

 Thanks,

Ramesh

UserImage.jpg
Alexandre Michotte

Still something is fishy with it, or I don't understand how it works. But somehow, 

(Week_GetWeekNumberByDate(0,TextToDate("31-12-2023")) is "1" (31-12-2023  is a sunday)

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.