summary of invoices

[bigmac]

Hi

I need a calculation that finds invoices 6 months or younger connected to a certain customer number and displays the total invoiced for that period. I.e. that calculation will update daily.

I'm thinking of something like this:

sum of Invoice_ToBePayed where date > today - 6 months

but there is no "where" function in filemaker, is it? How can this be solved?

[databaser]

there may be a better way, but this comes to mind quickly:

field 1:

((today - invoicedate) < 180) * amount

field 2:

summary: total of field 1

Edited July 6, 2008 by Guest