This function GetWeekNumber()/ accepts a date as string and returns the week number.

See also WeekOfYear .

GetWeekNumber('Date')

GetWeekNumber('23.08.2006')

returns 34

GetWeekNumber('2022-04-12')

liefert 16, which corresponds to the American calendar, on the other hand, delivered:

WeekOfYear('2022-04-12')

The value 15, furthermore you can use the function WeekOfYear auch das Berechnungsformat angeben, z.B.:

WeekOfYear('2022-04-12', 0)

liefert 16