topic Re: Create week number from date in App Development

Create week number from date

Aspiring_Developer — Mon, 21 Feb 2022 11:50:32 GMT

Hi ,

I have below dates and i need to calculate week number for each month.

I tried using simple week(Date ) but it not giving me the correct output:-

Here the date format is DD/MM/YYYY and 17 Feb is not the 7 the week ., it should be 3 as it is the 3rd week of the month.

How can I populate the week number for each month ?

Can anyone please help ?

@sunny_talwar @Kushal_Chawda

Re: Create week number from date

Or — Mon, 21 Feb 2022 11:54:39 GMT

This depends on what your definition of "week of the month" is. There are multiple methods for splitting weeks across years and months, so there's no one solution. Depending on which one you want to achieve, the required formulas are different.

Re: Create week number from date

Aspiring_Developer — Mon, 21 Feb 2022 14:07:51 GMT

Hi @Or

I wish to achieve the week distribution for each month .

I have dates commencing from year 2010 till now.

I wish to achieve below set of format :-

What should i do ? 😞

Re: Create week number from date

Or — Mon, 21 Feb 2022 14:02:13 GMT

That doesn't answer the question - how are you determining the week numbers within a month?

If you're looking for the same logic as the regular week() function, you can use 1+ Week(Date) - Week(MonthStart(Date)) (in your example, it'd be 1 + 7 - 5 = 3), but this may not work as you expect depending on the desired logic and which day the month happens to start/end on.

Re: Create week number from date

Or — Mon, 21 Feb 2022 14:15:45 GMT

So, based on that logic, it looks like the first seven days are always week 1, the next seven are always week 2, etc, no matter what the weekdays are?

In that case, you could use something like:

Floor((Date - MonthStart(Date))/7)+1

Or a similar mathematical function to just figure out which set of seven days the date in question falls in

Re: Create week number from date

MarcoWedel — Tue, 22 Feb 2022 20:36:21 GMT

Div(Day(Date)-1,7)+1

Re: Create week number from date

MarcoWedel — Tue, 22 Feb 2022 21:16:03 GMT

Ceil(Day(Date)/7)