Recent content by H1004

One thing to note is that I'm setting this up in a macro, and the To field somehow doesn't like just Environ("username")...Is there something else that I need to put in??? I've tried &Environ("username") And I tried Environ('username')

Yes, that is my intent for them to email this report to themselves once they are done with the program. And that's why I want to use Window NT ID with @company.com Thank you

I'm using a sendobject macro to automatically send email to the user with the result from Environ("username". In the To section, I wrote Environ("username")&@company.com But that doesn't work...What am I doing wrong? thank you

Actually, I try the following code, and it displays the day of the week now instead of blank, but the data is wrong...It seems to always be a day ahead. So instead of Friday, it would have a result of Saturday. Here is my code: ENDDATE/I6YMD = REQUESTED_DATE; DAYOW/A3 = DOWK(ENDDATE,DAYOW)...

I tried using the the method where if the enddate is on a weekday, then I'll increment the result to 1, but if it lands on a Saturday or Sunday, then I'll leave it alone. However, I tried using the following function to determine the weekday, but it is not working for me. Am I doing something...

I have a problem calculating business day because it is short on one day: For example: TODAYDATE/WYYMD=&BEG; DIFF/I8=DATEDIF(TODAYDATE, ENDDATE, 'BD'); Suppose TODAYDATE = 20041211 (Saturday) ENDDATE = 20041218 (Saturday) The diff will come out as 4; however, I wanted to come out as 5. The...

Thank you, it works great!

I figure it out on how to calculate it, but then I'm having difficulty trying to get WKDT or MTHDT into variable so that I can use it in my where statement. Example: WHERE REQUESTED_DATE LE '&ADVDATE'; Here is my code: DEFINE FILE ALLWORK4SCHED DATE1/YYMD='&RCD'; WKDT/YYMD = DATEADD(DATE1...

I even try doing this, and it still doesn't work. SELECTDT/YYMD = DATEADD(&RCD, 'D', 7)

I search for other thread concerning this issue, but it doesn't help my situation. I have a graph in (FEX1) with a requested_date as a drill down parameter into FEX2. It passes in a date with the following format: 2004/12/05 After it passes in, I want to add 7 days to it, so the result is...

I need to pass at least 3 variable along with the url string that callS the FEX(WORK). Somehow, it lets me pass the value, but not variable. Please help with the syntax. This one works: "http://servername/folder/ibi_cgi/ibiweb.exe?IBIF_ex=WORK&BDATE=20041122" However, this one doesn't...

I currently have WebFocus version 4:36, and I want to be able to incorporate two graphs into one page. I tried the following code, but it is giving me error message. And both file work okay independently; however, when I do include, it doesn't work. Here are my codes: SET GRAPHEDIT = OFF...

The reason it didn't work for me the first time was because I didn't run it in the MRE, but through Desktop Power Reporter. However, I have another question, which has to do with formatting. I tried to make the hyperlink to have the white color, but instead it default to blue. Is there a way...

I have an html page with form that ask the users for unit# & password. Let's call this page htmlPg1. After I submit this htmlPg1 page, it would go to another html page called htmlPage2 & ask for more criteria. However, I want save unit# and password in a variable & hopefully carry it to...

I tried the later piece of code, and I got error msg: FOC227: THE FOCEXEC PROCEDURE CANNOT BE FOUND: TEMP0037FOCEXEC*