Week number from day number

BlueRabit
Level 2
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

0 Kudos
1 Reply
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.

--Tom
0 Kudos