Hi @roccolord
You can use Python in PAD:
import datetime
week = datetime.date(%CurrentDateTime.Year%, %CurrentDateTime.Month%, %CurrentDateTime.Day%).isocalendar()[1]
print(week)
Please notice it uses the ISO week date standard (ISO-8601), which means that if you try to run this script with 1/1/2021, it will return week 53:
If you want to consider 1/1/2021 the first week, then you need to adjust the code:
import datetime
week = datetime.date(%CurrentDateTime.Year%, %CurrentDateTime.Month%, %CurrentDateTime.Day%).isocalendar()[1]
first_week = datetime.date(%CurrentDateTime.Year%, 1, 1).isocalendar()[1]
if first_week == 52 or first_week == 53:
if %CurrentDateTime.Month% == 1 and week == 52 or week == 53:
print(1)
else:
print(week+1)
else:
print(week)
Please also notice this week number system considers the starting on Monday and ending on Sunday.
