Skip to Content
0
Sep 25, 2020 at 01:39 PM

Extracting a week number from data in a YYYYWW format

109 Views

Hi All,

I was wondering if somebody can assist me?

I'm trying to extract the week number from an object with a date format of YYYYWW (202001 - 202052) So basically the last 2 digits but I don't want the leading zeros for weeks 1 - 9. Also I would like it to be in a text format so I can merge with the rest of the weeks (Creating a new variable)

Is this possible?

Many thanks,

Alex