Search results for query: *

Does any one know the table on V.4 repository which holds login details. I need to pull off the login that was connected at a particular point in time in the past week. Thanks for your help A

Fair Comment, Your soloution, which I also had from the Bus Obj help desk is the only way to take into account holdidays/Bank holidays etc...

Thanks For the info, In case anyone else is interested here's what I've used : select (( to_number(trunc(END DATE,'D') - trunc(START DATE +6, 'D')))/ 7*5) + mod(7 - to_number(to_char(START DATE, 'D')),6) + least(to_number(to_char(END DATE, 'D')) - 2,5) from TABLE NAME Substitute START DATE...

I need to be able to return the working days between 2 dates. I know of the daysbetween function but this is of no use when the time difference spans over a weekend. Does anyone know of a script / mathamatical formula to work this out? Also does BO v.4.1.4/4.1.6 support PL/SQL? Thanks in advance A

Anyone done it yet? I've got the ODBC update. It let's you query Note's database's through SQL. I can see the columns and tables no problem, I've set the universe up, the connection test's successfully but when I go to run the report it display's the general ODBC message. Any Idea's? Has...

Yaffle is right, DAS will scheduale it, You then need a script to zip it (if you wish) and send via mail (Outlook for sure, Im working on Notes)

Does anyone know how to get Business Object's (V.4.1.4.) accessing a lotus notes database file. I have a program (NotesSQL) that enables it access to the note's database's via SQL but I can't get the connection configured correctly on Business Objects. Thanks in advance