XPath Week-from-DateTime

Last update: Edit

1 Overview

The week-from-dateTime() function extracts the week number (in the year) from a Date and time attribute so it can be used to compare to a value. Values range from 1 to 53.

2 Example

This query returns all the logs where the date DateAttribute falls in the second week of the year (for example, “2011-01-13”):

//Logging.Log[week-from-dateTime(DateAttribute) = 2]

3 Read More

The following links are for the relevant documentation on how week number is calculated for a specific date for many of the databases used with Mendix.

The HSQLDB database used for testing locally uses JVM’s Calendar.WEEK_OF_YEAR.

PostgreSQL, Oracle, and MySQL follow ISO 8601:

Other databases have a more specific behavior: