Solved produce the number of week of the month (1 Viewer)

Alvein17

New member
Local time
Today, 15:39
Joined
Sep 2, 2021
Messages
29
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.
1630568286752.png
 

Gasman

Enthusiastic Amateur
Local time
Today, 08:39
Joined
Sep 21, 2011
Messages
14,037
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
Local time
Today, 04:39
Joined
Jan 11, 2013
Messages
3,849
Curious what happens to the months with 31 days, not to mention February and leap years.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 16:39
Joined
May 7, 2009
Messages
19,169
if consistent, you have your date filled:

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

jdraw

Super Moderator
Staff member
Local time
Today, 04:39
Joined
Jan 23, 2006
Messages
15,361
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
Local time
Today, 15:39
Joined
Sep 2, 2021
Messages
29
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
Local time
Today, 15:39
Joined
Sep 2, 2021
Messages
29
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
 

Users who are viewing this thread

Top Bottom