Extract week number from Date and Time field using Field Calculator in ArcPro

[RachelS]

Hi,

I'm hoping someone can help me to extract the week number from a date and time field using Field Calculator in ArcPro. I've tried a few codes I've found online but nothing is working.

My layer is called oyster, my fieldnames are surveydate and weeknumber.

Thanks

Rachel

[RachelS]

That's it, works perfect, although I didn't have to put ISO in front of Week.

Thank you!

[KenBuja]

There's difference between the two. Week returns a value where the first week is 0 while ISOWeek returns a value where the first week is 1. Take a look at the difference using your example date (remember that month is zero-based)