No announcements

### Calculating difference between 2 Dates.

I hope someone can help. I need to calculate the difference between 2 dates.  I can do this with 2 TimePickers, but this is not what I ...
| 3 Replies | 835 Views | Created by Hendri Bissolati - Saturday, July 6, 2013 2:13 PM | Last reply by Kareninstructor - Saturday, July 6, 2013 2:43 PM

### Intersecting month between 2 dates

You may want to try this. It basically employs the use of date extremes of the current month and verifies if falls in between the DueDate and FinalDate or vice ...
| 7 Replies | 1517 Views | Created by Agenteusa - Wednesday, October 8, 2014 4:25 PM | Last reply by Agenteusa - Thursday, October 9, 2014 2:54 PM

### query between 2 databases

an erorr as soon as I put the secnd table from the second file,as not recognized object. Is there a way to query these 2 databases  or I have to work it all out in the ...
| 8 Replies | 4665 Views | Created by Barbi Rio - Tuesday, June 16, 2009 12:13 PM | Last reply by DaleTurley - Thursday, June 18, 2009 7:52 AM

### Calculating % change between 2 dates

Hi all,  I want to show a pivot line chart of 3 things: 1) Index values 2) Index % change (from date to ...
| 6 Replies | 1141 Views | Created by עמיתת - Thursday, July 16, 2015 10:14 AM | Last reply by עמיתת - Tuesday, August 4, 2015 7:06 PM

### Confusion between 2 queries

Hi   I was hoping that someone will be able to explain to me what the difference is between these two queries, because i get
| 7 Replies | 5497 Views | Created by Carel Greaves - Monday, July 30, 2007 3:25 PM | Last reply by Arnie Rowland - Monday, July 30, 2007 4:00 PM

### INSERT two table with PHP MSSQL sqlsrv

Unfortunately no expert in mssql :( the relationship between tables is (Carrelli) ID -> (RigheCarrello) IDCarrello The question ...
| 2 Replies | 7845 Views | Created by Santpir - Thursday, December 3, 2015 3:23 PM | Last reply by Sebastian vd Putten - Tuesday, May 3, 2016 12:59 PM

### find data between 2 dates

//pass here the value of the date 2 //and rest of the ...
| 7 Replies | 2209 Views | Created by E_gold - Monday, August 1, 2011 12:25 PM | Last reply by Lie You - Monday, August 8, 2011 3:33 AM

### Getting individual dates between 2 dates

should be 0.  So in this case the dates between 7/2 and 7/7 involve 1 holiday and 2 weekends days.  Based on a 12 hour a day time window for reporting ...
| 12 Replies | 5283 Views | Created by kiloez - Tuesday, March 4, 2008 5:50 PM | Last reply by SQL-PRO - Tuesday, March 4, 2008 6:10 PM

### Searching between 2 dates (date Range)

scope containing all required sites and use &s="contentsource_name" in your search query URL to return results only from the desired scope ...
| 3 Replies | 4845 Views | Created by Brooke Burke-Charvet - Monday, September 21, 2015 4:51 PM | Last reply by Chris yuri - Tuesday, September 29, 2015 2:53 AM

### find data between 2 dates

Also note that if there is a time in addition to the date, you should rather use, in order to get anything for the first of August 2011 (note that # assumes that you are using the US format
| 3 Replies | 2325 Views | Created by E_gold - Monday, August 1, 2011 12:25 PM | Last reply by Vanderghast - Monday, August 1, 2011 8:59 PM

### Calculating difference between 2 dates

I need help in calculating the difference between 2 dates (the result should be like "1 year, 2 months and 15 days"). I am ...
| 7 Replies | 3463 Views | Created by Victor77 - Sunday, January 6, 2008 8:51 AM | Last reply by Marcel Nita - Sunday, January 6, 2008 3:40 PM

### Date Select Query - select between two dates

This kind of query is best accomplished using dates in standard format 'yyyy-mm-dd', which is always unambiguous regardless of your and your server current date ...
| 5 Replies | 39517 Views | Created by mustfa - Tuesday, August 22, 2006 8:38 AM | Last reply by Deezery - Saturday, July 5, 2008 10:29 PM

### get days between 2 dates

i need a query that gives me all days between 2 dates e.g. date1 = 2008/08/18          date2 = ...
| 3 Replies | 5002 Views | Created by flo_nie - Monday, August 18, 2008 12:04 PM | Last reply by Jagatheesan - Monday, August 18, 2008 12:54 PM

### Difference between 2 dates in a database

Are you talking about comparing dates on client or server?
| 5 Replies | 3268 Views | Created by RufusLDK - Wednesday, February 14, 2007 9:54 PM | Last reply by RufusLDK - Tuesday, February 27, 2007 12:54 PM

### How to get date difference between 2 dates?

This would be for all users.  I am looking to basically throw the user a error if they try to book a room in between or at same time someone else has booked a specific room....thnx
| 3 Replies | 541 Views | Created by 41globalit - Tuesday, October 27, 2015 5:55 PM | Last reply by KRISHANA KUMAR - Wednesday, October 28, 2015 7:40 PM

### count the days between 2 dates

where dt between '20110101' and '20110114'; Result: 14     AMB ...
| 4 Replies | 4472 Views | Created by cnsuman - Friday, January 14, 2011 12:07 AM | Last reply by Hunchback - Friday, January 14, 2011 12:55 AM

### calculate number of days between 2 dates

of work days between 2 dates, however, I get the #num! error message if there is a negative day, which I need to show as well. ...
| 4 Replies | 1556 Views | Created by SharePointGuy123 - Wednesday, May 28, 2014 1:41 PM | Last reply by SharePointGuy123 - Wednesday, May 28, 2014 6:52 PM

### MSSQL.1, .2, .3....?

For some reason Sql 2005, by default, creates different folder paths (such as MSSQL.1, MSSQL,2, etc) for different services. 1. Is there a utiltiy that ...
| 2 Replies | 15712 Views | Created by edm2 - Friday, July 21, 2006 3:48 PM | Last reply by Jonathan Kehayias - Friday, January 25, 2008 11:08 PM