Calculated field for first date?
-
- Posts: 9
- Joined: Tue Oct 10, 2017 12:44 pm
Calculated field for first date?
I want to print a monthly statement that lists each invoice in the month with a typical description row that includes the invoice date. The problem: At the bottom of the invoice I would like to print the date range of the invoices, i.e., "This monthly statement inludes invoices from first_date to last_date." How do you capture and print the first date in a series of customer invoice records on a group footer line?
=> Calculated field for first date?
You would create a group total that is a minimum of the date field and then place the total on the group footer. It will show you the earliest date for that group.____Kathleen__R&R Support