How to find the week number, and deduct the dates

[ppr (Peter Preuss)]

@AaronMark

Have a look here:

Convert Week into Date

@jahidKM lets do following: lets split the 03.2021 into year and week [grafik] init the first Year day, calculate the offset to the first friday of the year [grafik] retrieve the week offset (same week or next week) [grafik] So we can do the final calculation [grafik] Find starter help here GetFriday_FromWeekNo.xaml (7.1 KB) in .Net 5 a function for this was added, but unfortunately we cannot use it, as we do run via different infrastructre (.Net Framework)

Maybe you will combine it with this:

How to get range date "Monday-Friday" of the previous week

Hi to all, I’m not very good at programming, and have a problem finding a specific date range. I should develop a BOT that will theoretically go into action every Monday and maybe every Tuesday, but, regardless, I need to collect the range-date from “Monday” to “Friday” of the previous week just ended. These two dates, I have to use them to set up a search query on SAP. [image] So, regardless of the bot’s RUN day, the range date of the previous week. Can anyone help me with this please? t…