Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ginkoba

    Help with pulling data for 4 months including 1 month back.

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

    Help with pulling data for 4 months including 1 month back.

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

    prior month in addition to current month

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

    prior month in addition to current month

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

    prior month in addition to current month

    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?
  6. ginkoba

    within 2wks of currentdate

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

    within 2wks of currentdate

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

    within 2wks of currentdate

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

    help with if then else

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

    help with if then else

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

    How to exclude current date in Max and Min formulas

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

    How to exclude current date in Max and Min formulas

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

    How to exclude current date in Max and Min formulas

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

    How to exclude current date in Max and Min formulas

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

    calculate the exact number of working days in the last fullmonth

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

    calculate the exact number of working days in the last fullmonth

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

    calculate the exact number of working days in the last fullmonth

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

    Text field keeps truncating or missing some pages

    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?
  19. ginkoba

    Text field keeps truncating or missing some pages

    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?
  20. ginkoba

    Calculating work days

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

Part and Inventory Search

Back
Top