Invoice Count by Supplier From Prior Month

Summary:

COUNT function to display number of invoices by submitted from supplier in prior month using Dynamic Date scheduling

Content (required):

Hi All,

Using the COUNT function, we need to see how many invoices were submitted from a supplier in the prior month. Does anyone know what the formula looks like to accomplish this?

I know the dynamic date formulations for

First day of previous month:

TIMESTAMPADD(SQL_TSI_MONTH, -1, TIMESTAMPADD( SQL_TSI_DAY , DAYOFMONTH( CURRENT_DATE) * -(1) + 1, CURRENT_DATE))

and

Last day of the previous month:

TIMESTAMPADD( SQL_TSI_DAY , -(1), TIMESTAMPADD( SQL_TSI_DAY , DAYOFMONTH( CURRENT_DATE) * -(1) + 1, CURRENT_DATE))