<div>
That would certainly work-however, I'm going to have to update the starting date every month. &nbsp;I was hoping a query could be built to know when the 19th of each month is.
</div>


That would certainly work-however, I'm going to have to update the starting date every month.  I was hoping a query could be built to know when the 19th of each month is.

<div>
<div class="content wysiwyg-content">
I'm using the Avaya CMS Supervisor client and do have access to design custom reports with sql queries. &nbsp;How do I create a query that always shows me a month to date number when the first of the month is 19th? &nbsp;Specifically, I'm wanting to know the service level MTD each day.
</div>
</div>


I'm using the Avaya CMS Supervisor client and do have access to design custom reports with sql queries.  How do I create a query that always shows me a month to date number when the first of the month is 19th?  Specifically, I'm wanting to know the service level MTD each day.

How to create a query that pulls a month to date number

IP telephony (Internet Protocol telephony) is a general term for the technologies that use the Internet Protocol's packet-switched connections to exchange voice, fax, and other forms of information that have traditionally been carried over the dedicated circuit-switched connections of the public switched telephone network (PSTN). Using the Internet, calls travel as packets of data on shared lines, avoiding the tolls of the PSTN. The challenge in IP telephony is to deliver the voice, fax, or video packets in a dependable flow to the user.

IP Telephony

Telecommunication occurs when the exchange of information between two or more entities (communication) includes the use of technology. Communication technology uses channels to transmit information (as electrical signals), either over a physical medium (such as signal cables), or in the form of electromagnetic waves. The word is often used in its plural form, telecommunications, because it involves many different technologies.

Telecommunications

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.