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))
Tagged:
0