NOTE: If the source Datetime value does not include a valid input for this function, a missing value is returned.
There are differences in how the WEEKNUM function is calculated in Photon and Spark running environments, due to the underlying frameworks on which the environments are created:
- Photon week 1 of the year: The week that contains January 1.
- Spark week 1 of the year: The week that contains at least four days in the specified year.
Column reference example: