I have a string column e.g. 2024-32 indicating that it is the 32nd calendar week of 2024. Can I use the Cast to Date transformation in pipeline builder? In common programming languages the letters “V” or “w” are used to indicate calendar weeks in date formats e.g. “yyyy-ww” but this doesn’t seem to be supported. Is there an alternative?
Hey @bauer until it’s supported I think you would need to convert it by taking the week and multiplying by 0.23 (one week = ~0.23 months) to get which month that week falls in and either estimate the day or if you’re okay with month and year converting to a date using yyyy-mm
1 Like