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

    Format DATEDIFF output

    Thanks, but I was realy looking for a SELECT statement that could do it all in one go, e.g. select (((DateDiff(ss, StartTime, EndTime) /60)/60)/24) as days, ((DateDiff(ss, StartTime, EndTime) /60)/60)%24 as hours, ROUND(((((((DateDiff(ss, StartTime, EndTime) /60.0)/60.0)/24.0)- (((DateDiff(ss...
  2. Borgis

    Format DATEDIFF output

    So exactly how would this fit into a select statement??? select date1, date2, DATEDIFF(datepart,date1,date2) from table1 Don't think it would work, but I could be wrong
  3. Borgis

    Format DATEDIFF output

    I have two date/time values 26/08/2003 13:55 18/08/2003 14:00 I need to calculate the difference between them and format the result in days, hours, minutes e.g. the results from the select would be like below Start End Days Hours Minutes...
  4. Borgis

    How do I fire an add-in when document opened in word

    I have an URGENT requirement, that whenever a document is opened in Word an add-in is called. I kind of know about add-ins, but don't know how to 'call' it whenever a document is opened in Word. If anyone has any code examples, that would be GR8 :-D. Cheers, B
  5. Borgis

    ReDim array

    I am trying to copy values from one array into a new one, however I don't know how many columns or rows are going to be needed for the new array. I have tried to ReDim the array but it does work. Can anyone tell me what's wrong with the code. Thanks numrows=ubound(arrRecords,2)...

Part and Inventory Search

Back
Top