# Solvedproduce the number of week of the month (1 Viewer)

#### Alvein17

##### New member
Hello guys,

I have query design based on table. like as my post thread tittle ,
i want to counting number of week in one month. with criteria like Jan ,1 2021 until jan,10 2021 as week 1 and jan, 11 2021 until jan, 20 2021 as week 2 .
also i want separated week of the month to be 3 weeks/monthly only ( 1 week = 10 days ).
what does query i have used? i was try to use query like Fields "Ket" but that query only counting week.

#### Alvein17

##### New member
here i show table what i want it

#### Gasman

##### Enthusiastic Amateur
Not a week then, just a period of days?

Use the INT() function with the number of days since beginning of month, dividing by your period, which is 10.?

#### moke123

##### AWF VIP
Curious what happens to the months with 31 days, not to mention February and leap years.

#### arnelgp

##### ..forever waiting... waiting for jellybean!
if consistent, you have your date filled:

Ket:Switch(Day([Tanggal]) < 11, 1, Day([Tanggal]) < 21, 2, True, 3)

#### jdraw

##### Super Moderator
Staff member
Seems in reality it has nothing to do with week. May be better described as which 10 day period in a given month.
I think this is one of those times where a little more context and rationale would assist with communications.

#### Alvein17

##### New member
Curious what happens to the months with 31 days, not to mention February and leap years.
hello thank you to attend in my post thread,

if days of the months 31 days it will be in weeks/periode 3.

#### Alvein17

##### New member
Not a week then, just a period of days?

Use the INT() function with the number of days since beginning of month, dividing by your period, which is 10.?
hello,

maybe you right sir, period of days not week hehehe
oke let me try your suggest sir.

thank you

#### Alvein17

##### New member
if consistent, you have your date filled:

Ket:Switch(Day([Tanggal]) < 11, 1, Day([Tanggal]) < 21, 2, True, 3)
thank you sir,

let me try first sir.

#### Alvein17

##### New member
if consistent, you have your date filled:

Ket:Switch(Day([Tanggal]) < 11, 1, Day([Tanggal]) < 21, 2, True, 3)
Hey sir, thank you it's work.

Godbless you sir.

Replies
5
Views
260
Replies
12
Views
394
Replies
12
Views
327
Replies
4
Views
254
Replies
7
Views
382