calculate no of week from a date

prash_
Level 2
calculate no of week from a date

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?

0 Kudos
3 Replies
Turribeach

It depends on where you need this to be calculated. Is this for a Prepare recipe, Python recipe, Jupyter Notebook, Scenario, etc?

0 Kudos
prash_
Level 2
Author

In prepare recipe

0 Kudos
Turribeach

Use a Formula with DatePart and ‘weekOfYear’ or ‘isoWeekOfYear’:

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

 

0 Kudos