Week number from day number
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
Answers
-
tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,618 NeuronI 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.
-
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 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,618 Neuron
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
