Skip to Content
Former Member
Nov 09, 2007 at 06:17 PM

Print future date(s) on report


Post Author: jennpo

CA Forum: Formula

I have a report that uses data from a table to collect sales by month and year. I've also created a formula that prints the forecasted sales by month and year. I use month and year from the sales table to group the data. I need be able to print the month and year forecasted sales on the report for dates in the future. Any ideas on how to make this work.

I was able to find a formula that will show data for dates not in a table but it works on a beginning and ending date and shows the missing dates in between. I need the dates after the last date in the table.

I appreciate any help I can get.