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

    Login Details On Repository

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

    Calculating Working Days

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

    Calculating Working Days

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

    Calculating Working Days

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

    Accessing NOTES Databases

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

    Automatic mail

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

    Business Objects Using Notes SQL

    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

Part and Inventory Search

Back
Top