Hello,
In the select expert, I have the following:
{benefit.tax_year} = (left(cstr(year({?enddate})),1) + mid(cstr(year({?enddate})),3,3))
or
isnull({BENEFIT.TAX_YEAR})
{benefit.tax_year} is a string value
When running the report, I am using the {?enddate} of 9/30/2004, so the report is...
I am trying to calculate the average # of days per examiner based on policy numbers but am having problems. For each policy, I calculate the # of business days it takes from time received to the first time action was taken. My formula is as follows:
{@days_intial}
WhilePrintingRecords;
DateVar...
Hello,
I need to have a count of business days for each month placed in the report footer. The report has a set beginning date and the user inputs the ending date, therefore the ending date changes everyweek. I have gotten it to work great for the current month. I have also found a way to do...
Is there a way to calculate the business date for each month, without creating a month group band?
When I use this formula using a month band it works great:
//begin formula
datevar fd;
datevar ld;
numbervar loop;
local numbervar busday;
numbervar span...
I need to have a count of business days grouped for each month. I have been able to figure out the total count but cannot get it to count only business days for each month...any suggestions???
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.