I am writing a report to show contract billing coverage for maintenance contracts.
Billed on January 1, covered for 3 months including January. (January, February, March) Then it will be billed in April and should say April,May,June. etc.

I think I can do this 2 ways, take the invoice date because it is invoiced at the start of a new coverage period, or take the start date for the year and figure out the amount of billings and get it from that. I just don't know how to execute, Pics attached with what I have and what i would like to achieve.

What I have:



What I would like:

That did it! I was using the date add function but could not figure out how to get the date as a string not a number! I replaced (currentdate) with my invoice date field and it works perfect.