and sorry for the “trivial” post, but, I have a lot of difficulty understanding how to use the System.Globalization to manipulate dates.
I have to build a bot, which works only on Mondays, intercepting data from the previous week.
The bot works on SAP, and must set a date range in a query:
from Monday (last week) - to Friday (last week)
Basically, I would need help on this:
- I would need to know what number it was last week (ex for now: 6_2021)
- with this data, intercept which date was Monday (01/02/2021)
and which date was Friday (05/02/2021) of the previous week.
I must use this approach for the eventual recovery of sessions related to the previous weeks.
Basically, I thought that the bot should read the week from a table, and with respect to the week number in the table, calculate the appropriate range date.
I’m really clumsy with handling text strings and System Globalization … sorry sorry sorry…