To create an automated email program, I am performing some action based on the week of year. I am referencing the datepart() function, and want to convert NOW() into the current week of year - ie: Jan 15, 2019 --> 3.
I do not see documentation for native support of that conversion; so then I though to convert NOW() into current day of year - ie: Jan 15 2019 --> 15; Feb 1 --> 32 from which I could / 7 to get close to the week-of-year. I also don't see native support for this in ampscript.
As a workaround, I am generating the week-of-year in a tsql query while selecting subscribers in SFMC:
DatePart(weekday, GETDATE()). This feels inefficient since it will generate the exact same value for every subscriber.
Has anyone encountered this problem before? What did you do? Am I missing something?