Week number from day number

BlueRabit

We consider that we have a table that contains a column "Day".

In this table we have values like "21", "10", "16", .... anyvalue that could correspond to a regular day number from a date.

Starting from this, is there ay formula that could return me the week number of the year corresponding to this day number (for this actual month) ?

Thank you for your time,
BlueRabbit

tgb417

@BlueRabit

I think I understand what you are getting at.

In a visual recipe in a couple of steps, you could change the numbers into a parsed date. With the Parsed Date Step type. Then from the parsed date, there is a step that will provide date parts.

If this is not to your point, please share a bit more detail. It is often to share a few example record and the output you expect to get.

Monica1

How do I get the week number out of the date, as in the 1st week of January of any year should be "1", the second week "2" and so on till 52 weeks

tgb417

@Monica1

Here is a earlier community post.

https://community.dataiku.com/t5/General-Discussion/Understand-datePart-formula/m-p/9464

Here is the documtatioin on the support language.

https://doc.dataiku.com/dss/latest/formula/index.html#date-functions