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.
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.