Search results for query: *

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

Thanks Ian. I'm aware of that formula but in my case, there are no prompts/parameters dates to count in between. I'm using the lastfullmonth. The thing is, I want this report to run every 5th or whatever of the month for the lastfullmonth without me putting in the parameters. So if today is...

I'm using the below formula to derive the exact number of working days(-sat, sun) for the last full month. For some reason, each month, I have to manually adjust for 1 or a couple of days depending if the month has 30 or 31 days. I thought my formula was doing this automatically but some how...

Thanks Ian but in my case, I'm not grabbing the text field from a database but rather creating it within the report. How do I get around this?

I am attempting to build a report to display a huge text field with a couple of formulas(vendor name, address, zip) on the top first page. Each time I run the report I get just a few pages of a total of 11 to display. What am I doing wrong?

Hi all, I have a code that calculates the work days excluding saturdays and sundays. See code below. However, I want to further modify this so that "D1" would subtract 28 days for months 4,6,9,11 and 30 days for months 1,3,5,7,8,10,12 and so on and so forth. Please assist. Local DateTimeVar d1...