Recent content by TJIT

Last Thursday I systematically changed the two numbers at the end of this part of the script using combinations of 0's, 1's, and 2's: where mod(to_char(sysdate,'IW'),2)=0 I found that ,2)=1 resulted in no action being performed (in my case an email didn't get sent out) I also found that ,2)=0...

If I run the procedure manually, it runs just fine. It's been running great for a few years. It was only when it needed to run the first time in January that it stopped working. That's why I think it's calendar related. The software this runs in is called IQALERT and is part of our...

This is used in an automated emailing software as a "condition statement". It tells the software to only run and email a particular report every other week. It was working consistently right up until the first payroll of January. Nothing in the report or any other area of the software...

Few years ago someone created a script to set the condition where an email only gets sent on a Thursday of the week we get paid (which is every other week). It's been working for a few years but suddenly stopped in January. I'm guessing it has something to do with it being a leap year, but...

Suppression formula did the trick. I created a parameter called "Label Type" (I'm working with labels so that's simply what I called them...could have called them anything) with "Allow multiple values" set to 'true' in the Value Options section of the "Edit Parameter:" window. I set the Type...

My report has multiple group headers with distinct static text at the top of each page. One section says "Startup"; another one "Shutdown"; another one "Restart"; etc. Currently, when they print all 3 pages print out. However, I'd like to offer them a prompt to only print the one or two pages...

I have a list of manufacturing part numbers similar to this: P-R-NTRL1 P-R-NTRL4 P-R-NTRL10 However, CR wants to sort them like this: P-R-NTRL1 P-R-NTRL10 P-R-NTRL4 I get why it does that but am not sure if/how it can be done correctly.

I love you, man!

In the example below (in the Details section of my report), if the values in the first column, "order no." are the same in that section/group, there should only be one row instead of two and the "on hand Qty" should be combined equaling 3700 (3100 + 600) ...but only when the "order no." fields...

Pete, The "first review date" is when the vendor came online with the company. Once that first review is done, their schedule synchronizes with all other existing vendors, which is currently 11-1-13. I added your new formula and got additional dates: http://i.imgur.com/QAd19Sp.jpg I have an...

I think we're onto something here, Pete. I am getting a couple rogue dates showing up which, if figured out, will call this one done. I am attaching a screenshot of the report with the two fields highlighted: http://i.imgur.com/5TIZfzV.jpg But otherwise, I think we're barking up the right tree.

Let me know if this helps. This first picture shows the front end user field asking for the "Original Review Date." http://i.imgur.com/ORCHPYv.jpg Once this date has been established, the report should show the first day of the next quarter...of this current year. The date in my...

Fisheromacse, I'm getting the same results using your formula as I was Pete's. I am pasting the formula below showing my input date (which is a formula called @Start_date): ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ numbervar m1; numbervar y1; IF Month({@Start_date}) in [2,3,4] then m1:=5 else if...

Actually I jumped the gun on my last post, Pete. Some of our starting dates are from 2001 and the formula: DateSerial(Year(CurrentDate),Month(CurrentDate)+3,1) Works only through the following year but then stops working; so that an input date of 11-2-2001 shows 2-1-2002 on the report I run...

This works perfectly! I just needed to change "(CurrentDate)" to coincide with my field and was done. Thank you so much, Pete. Ted