Given a one-to-many relationship between a Customer table and an Invoice table with the following fields:
Customer -
pk_Customer: ID
Invoice -
pk_InvoiceID
fk_Customer: ID
InvoiceDate -
Which formula can be used as the definition for a calculation in the Customer table that will count the number of invoices generated in the past 180 days?
Comments