Each month I want to pull billing records just for that month. Commercial accounts are always billed last each month but the date always varies. Currently I am having to enter the between dates by looking up a commercial account to see when it was billed the previous month (beginning date) and when it was billed in the current month ( add 1 day to it so it is included in query END DATE).
How would I automate that?
Each account has a bill month year and then a bill date as fields. So if I want May's records I need how would I pull the bill date field for april as beginning date and I need to pull the bill date for May and add 1 day to it for my end date. What would the syntax look like?