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