Recent content by ginkoba

Thanks much Brian, the 2nd option worked for me as I had a datetime field.

I'm trying to figure out how to find data within a 4 month period. So when the report runs, it should pull data for the last month(1 month back) + 3 months. So if I run the report now, it should pull all June, July, August and September. Can someone please assist with this. I have this formula...

Pete and all. Thanks for trying to help. This is what I have: Parameter based on {JD_GL_Job_Profit_SP.DocDate} called {@EndDate}. Only the last date of the month will be entered here. I have a running total formula that looks like this: {JD_GL_Job_Profit_SP.GroupMask} = 4 and...

Thanks for responding fisheromacse. Sorry for the confusion. let me rephrase this again: This is the formula I have right now: {JD_GL_Job_Profit_SP.DocDate} in dateadd('m',-1,{@EndDate}) to {@EndDate}. I'm trying to pull all dates of the prior month. So if the parameter entered is 5/31/13, I...

I'm trying to pull data based on a date parameter. So when the last date of the month is entered in the parameter field, it pulls all data for that month. In addition to this, I also want the report to pull data for the prior month as well. Can someone assist with this problem?

Mike thanks again. Here's what worked. I transposed the previous answer from you since I'm looking for 0-14. IF currentfieldvalue > CurrentDate AND currentfieldvalue <= dateadd('d',14,currentdate) THEN crYellow ELSE crNoColor

Thanks MCuthill. So if current date is 6/24/13 then everything between now and 7/8/13 should highlight. I'm not seeing that.

How do I write a function to highlight when it's within 2wks of currentdate. This is what I have currently and it is taking everything after the 14 days. I want everything from 0-14 not after the 14 days if currentfieldvalue>=dateadd('d',14,currentdate) then crYellow ELSE crNoColor

Thanks Ian. You're freaking awesome. Somehow I missed a combination. It works!

I created 2 optional parameters and have a couple of formulas for the user to either enter something or leave blank. They both work separately but wanted to combine them into one formula. Please see example below. When I put an else between the 2 formulas, it ignores the 2nd one. Can someone...

Thanks much LBass and Dell. I will give this a shot and let you guys know as soon as I can.

I'm using tables. Database is Oracle and my Crystal version is 2008. Don't want to exclude the current month in the filter as I want to see it on the report but not in my max function which will later be shown on a chart.

Thanks Dell and Madawc Williams, So this is a snapshot of the problem...These are all numbers for FY 2010. I have all these months summed up like the example below. Say when I apply the Max for Jan, I get 1346074 which is the current number for Jan but I don't want that number at all. I want it...

Is there a way to exclude the current date from a Max or Min formula? I'm trying to do a Max on a group of numbers for the past 5 years and one of them is from the current date. How do I exclude that from showing up? Any help will be greatly appreciated. Ginkoba

Thanks much Mike. I was able to modify Ken's formula along with a modified version of your formula producing the following: I did not include the holidays since I don't require them here just yet. You will note that I replaced "-1" with "-2" in the last line before "weeks + days" in order to get...