Recent content by silck

Not sure why it didn't before, but the following worked today: isnull({BENEFIT.TAX_YEAR}) or {benefit.tax_year} = cstr(({?enddate}),"yyyy") Thanks for all your help!!!

I have changed the select criteria to {benefit.tax_year} = cstr(({?enddate}),"yyyy") or isnull({BENEFIT.TAX_YEAR}) Using the {?enddate} of 9/30/2004, the report is still only pulling the 2004({BENEFIT.TAX_YEAR}). If I reverse it to: isnull({BENEFIT.TAX_YEAR}) or {benefit.tax_year} =...

Thanks for the suggestion, but that still does not resolve it.

In my report, that formula is pulling the 2004.

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...

Crystal 8.5 I have already looked at that route and it will not allow me to use running totals for that. thx.

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...

No, it is more like JAN FEB MAR Business days 20 21 20 The date is based on the date the report is being ran. Ex.- Joe runs the report for 6-30-2002. The report should only show the info that month and the previous months and nothing else. Also, this report...

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...

My fault, I was using the wrong date field in my formula. It is working great! THANK YOU SO MUCH FOR YOUR HELP!!! -Kim

Mike, That works great, but I have specified where a date range needs to be entered (ex. 1-1-2002 to 6-30-2002). How would I get it to calculate the count for each month? Thanks to all for your help!!!!

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???