Hi, could someone help me how to solve on how to count posts monthly?
Once a month i collect data from 6 months back from a database.
It uses todays date and gets me data 6 months back and puts it in
a table like below.
Then i want to count number of workorders per month, which i really dont know how to do.
The result should be like, January=45, Februari = 62 etc
Also, i would like to count number of entries in failurercode=10 in the current month.
Could someone please give me a tip on how to do this?
Once a month i collect data from 6 months back from a database.
It uses todays date and gets me data 6 months back and puts it in
a table like below.
Then i want to count number of workorders per month, which i really dont know how to do.
The result should be like, January=45, Februari = 62 etc
Also, i would like to count number of entries in failurercode=10 in the current month.
Could someone please give me a tip on how to do this?