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!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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...- Borgis
- Post #5
- Forum: Microsoft SQL Server: Programming
-
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- Borgis
- Post #3
- Forum: Microsoft SQL Server: Programming
-
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...- Borgis
- Thread
- Replies: 6
- Forum: Microsoft SQL Server: Programming
-
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- Borgis
- Thread
- Replies: 2
- Forum: Microsoft: Office
-
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)...
