Hey guys,
Looking to convert a date into a week number, much like the Excel formula =weeknum().
How can I do so?
Hi @Matias_O - You can use our Date Formatter step for that.
Set your old format by referencing the table in the step documentation linked above.
For your new format, put WW (in capital letters) and that’ll convert your date column into “Week of Year (ISO)”.
Let me know how this goes!
3 Likes
That worked, thank you Sachi.
2 Likes