Hello I am building a desktop flow and need to take week numbers. I take current week number with Python with the following script:
import datetime
week = datetime.date(%CurrentDateTime.Year%, %CurrentDateTime.Month%, %CurrentDateTime.Day%).isocalendar()[1]
print(week)
With this I am able to get current week number. The issue is I need to take previous 3 weeks. Unfortunately I get a lot of errors and have no idea how to make this work. I tried:
import datetime
week = datetime.date(%CurrentDateTime.Year%, %CurrentDateTime.Month%, %CurrentDateTime.Day%).isocalendar()[1]
week - datetime.timedelta(weeks=1)
print(week)
I tried the following code which works fine if the year did not flip (now I get 0, -1 and -2 instead of going to weeks last year):
import datetime
week1 = datetime.date(%CurrentDateTime.Year%, %CurrentDateTime.Month%, %CurrentDateTime.Day%).isocalendar()[1]-1
week2 = datetime.date(%CurrentDateTime.Year%, %CurrentDateTime.Month%, %CurrentDateTime.Day%).isocalendar()[1]-2
week3 = datetime.date(%CurrentDateTime.Year%, %CurrentDateTime.Month%, %CurrentDateTime.Day%).isocalendar()[1]-3
print(str(week3) + ",", str(week2) + ",", str(week1))
I either get invalid syntax, or trying to convert int to date etc. Is there a way to actually do this? I do not know Python at all so I am at a loss here.
What I want to achieve example: using current date I get 03.01.2023. With script I want to get the following string printed: "52, 51, 50".
