If I have today's date, how can I figure out which Wednesday of the year falls in the same week?
So, say today Thursday March 18, 2021, I want to figure out that yesterday Wednesday March 17, 2021 was the 11th Wednesday of 2021. Is there a way to do that with the ICUDateTime tokens in KM or some other way?
I would want the same regardless of what day I am actually checking from.
%ICUDateTime%D% is today's serial number in the year. Apply DIV 7 to this value for the integral number of full weeks in the year through today. Depending on what "in the same week" means, you can then adjust by 1 based on %ICUDateTime%c%, which is the day of the week, where Sunday is 1, Monday is 2, etc. For example, if today is Tuesday (%ICUDateTime%c% = 3) and you want to count the Wednesday that's tomorrow, add 1.