calculate no of week from a date
prash_
Registered Posts: 17 ✭
I have a date 2023-04-13 and I want fetch the no. of week the date has like its 13th of april so week no is
15 of a year. How this can be done in dataiku?
Answers
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,125 Neuron
It depends on where you need this to be calculated. Is this for a Prepare recipe, Python recipe, Jupyter Notebook, Scenario, etc?
-
In prepare recipe
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,125 Neuron
Use a Formula with DatePart and ‘weekOfYear’ or ‘isoWeekOfYear’:
https://doc.dataiku.com/dss/latest/formula/index.html#date-functions