Skip to Main Content
HCL Domino Ideas Portal

Welcome to the #dominoforever Product Ideas Forum! The place where you can submit product ideas and enhancement request. We encourage you to participate by voting on, commenting on, and creating new ideas. All new ideas will be evaluated by HCL Product Management & Engineering teams, and the next steps will be communicated. While not all submitted ideas will be executed upon, community feedback will play a key role in influencing which ideas are and when they will be implemented.

For more information and upcoming events around #dominoforever, please visit our Destination Domino Page

Status Under Consideration
Workspace Domino Designer
Categories @Formulas
Created by Guest
Created on Apr 11, 2019

Add a @Calendarweek formula function, which obeys the user's regional settings

Sometime users want to categorize documents in a view by calendar week.

The calculation of calendar week is differerent in different parts of the world, e.g. the rules for the US differ from the rules used in Europe.

The Notes client calculates the calendar week correctly, thus the necessary code must already be there and only needs to be made available.

Added bonus: also calculate the year of the calendar week, which can be different from the year of the date!

Example:

31st December 2018

US: Its the 53rd week of 2018

DE: Its the 1st week of 2019 (!)

 

This function could have three parameters:

  • date (date; optional): date to calculate the calendar week for; default is the current date
  • returnYear (boolean; optional): return the year of the calendar week; default is false (return week number)
  • region (String or Integer; optional): region to calculate the calendar week for; default is the user's current region
  • Attach files
  • Guest
    Reply
    |
    Apr 2, 2023

    Alternative solution maybe: add "W0" to @Text, i.e. to the symbols that can be used in the format string