Friday, June 04, 2004

FileMaker - Report by Month

I had the problem that I was trying to do a report by month, but the field that I was keying on had month, day, and year, so I was getting a breakdown by day. To breakdown by month, I introduced an unstored calculated field with a date result, using the formula

Date( Month(CalcDate), 1, Year(CalcDate))

…and keyed off that, instead.