Get monthly week number and day name from date time field

[ArnabSengupta]

Hi All,

I want to get the week number (Monthly) from my date time field.

For e.g. 2020-08-25 18:43:31 = Tuesday, 4

              2020-03-24 1:25:30= Monday, 4

              2020-07-14 13:20:40= Tuesday, 2 etc

Help is much appreciated.

Thank you!

[vizAlter · Accepted solution]

Hi @ArnabSengupta — Hope, the attached solution will be helpful.

FYI: 

%U — This will return the week number, as 00-53, with the beginning of weeks as Sunday.

%W — This will return the week number, as 00-53, with the beginning of weeks as Monday.

[vizAlter]

@ArnabSengupta — Thank you!

[Bazal]

I'm looking to build a similar flow but where the 1st of every month is considered as the starting date for counting week instead of a Monday/Sunday or any other day for that matter. 

For example, 2023-12-04 is Week02 with this flow whereas I would need it to be considered as Week01; similarly, 30th/31st is last week.

Along with this, I would need to have the month name column, so the final output is two columns: Month and Week no. of the month.

Can you please help me with that?

[Pratik1996]

Try this solution and confirm.