Calculated field for first date?

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Victor_(Guest)
Posts: 9
Joined: Tue Oct 10, 2017 12:44 pm

Calculated field for first date?

Post by Victor_(Guest) » Thu Apr 21, 2005 12:38 pm

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?

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> Calculated field for first date?

Post by kfleming » Thu Apr 21, 2005 12:59 pm

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

Post Reply