Convert date to year/week number format

Help Studio
,
1

Hello,

I would like to convert datetime to year/week format.

I have the datas in Excel like “2021.04.29.” and I would like to get in this format: “2021/17”

How can I do this in an Assign activity?

Any help much appreciated. Thanks.

2

getting the weeknumber:
CultureInfo.InvariantCulture.Calendar.GetWeekOfYear( YourDateTimeVar,CalendarWeekRule.FirstDay,DayOfWeek.Monday)

3

Yes, I got this, thank you so much, but I need the year too

4

grafik
grafik

ensure System.Globalization is imported to namespaces
grafik

2 Likes
5

Thanks for your help!

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.