Which expression would display the number of the calendar week?

You need to create an expression that displays the number of the calendar week from the beginning of the year, for example, 01 January 2017 to 07 January 2017 = week 1. The calendar is based on a January to December fiscal year. The Calendar table has the values shown in the graphic.

Which expression would display the number of the calendar week?
A . (today – (today + 0 Year) Week)
B . (today – (today + 0 Year) Week) +1
C . (today + 0 Week)
D . (today + 0 Week) + 1

View Answer

Answer: B

Explanation:

The expression to display the number of the calendar week from the beginning of the year takes today’s date, resets it to the start of the year (the 0 Year part), and then calculates the week number from this start date, adding 1 since week numbers generally start at 1, not 0.

ReferencesThe logic for calculating week numbers from a given date is commonly described in Kinaxis RapidResponse documentation and training materials concerning date and time functions.