DESCRIPTION:

The week() function is used to determine the calendar week of the year in which a date occurs. Keep in mind that this function returns its values based on the week of the year, not the date of the year (as demonstrated in the Example section of this page).

SYNTAX

  • week(‘Date Field’)
  • week(‘Appointment Field’
  • week(‘Date/Time Field’)

WHERE

  • week is the function keyword. This must be entered into the Ninox function editor in all lower-case characters
  • ‘Date Field’ is a valid reference to Date field in the table schema of a Ninox database
  • ‘Appointment Field’ is a valid reference to Appointment field in the table schema of a Ninox database
  • ‘Date/Time’ is a valid reference to Date/Time field in the table schema of a Ninox database

Things to keep in mind when constructing this function:

  • This function returns its values based on the week of the year, not the date of the year. This consideration is best represented by the image below:

SEE ALSO

Revision: 2
Last modified: 2019/11/10

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Please do not use this for support questions.
For customer support, please contact us here.

Post Comment