You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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))

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!