smtazulislam
Member
- Local time
- Today, 05:47
- Joined
- Mar 27, 2020
- Messages
- 806
We have 1297+ foreigner workers who is work with us as work resident permit (WRP) . We called this resident permit card "IQAMA". Iqama have valid date and it is can renew by 3 Months / 6 Months / 9 month and 12 month (1yr) upto 3 yrs .
We facing a problem that some month we have 250+ Iqama's for renew list and some month is 50 + AND some month is NULL.
So, we would like to a query that all employee EXPIRED date / 12 Months = if we wish divide to [By 3 Months] or [By 6 Months] Or [By 9 Months] Or [By 12 Months]
Then lists become average same QUANTITY in per month/Year.
Here we need same quantity by 12 Month BY DIVIDE EXPIRE_DATE
We facing a problem that some month we have 250+ Iqama's for renew list and some month is 50 + AND some month is NULL.
So, we would like to a query that all employee EXPIRED date / 12 Months = if we wish divide to [By 3 Months] or [By 6 Months] Or [By 9 Months] Or [By 12 Months]
Then lists become average same QUANTITY in per month/Year.
MONTH NAME | NOW [QUANTITY] | EXPIRE DATE | WE LOOKING |
---|---|---|---|
JAN | 0 | 1-1-2023 TO 31-01-2023 | |
FEB | 258 | 1-2-2023 TO 28-02-2023 | |
MAR | 308 | ||
APR | 15 | ||
MAY | 25 | ||
JUN | 168 | ||
JUL | 354 | ||
AUG | 2 | ||
SEP | 5 | ||
OCT | 125 | ||
NOV | 32 | ||
DEC | 5 | ||
TOTAL | 1297 |
Here we need same quantity by 12 Month BY DIVIDE EXPIRE_DATE
Last edited: