Stack Overflow
Stack Overflow

Questions tagged [date-range]

Date-range refers to a range of dates, i.e. a period of time between a start date and an end date.

Date-range refers to a range of dates, i.e. a period of time between a start date and an end date.

Date range is commonly used:

  • as search criterion for any date related data,
  • when operating on data referring to periods of time.
1608 questions
0
votes
3 answers

JQuery UI date picker end date 1 day after start date

So i am trying to restrict the user from selecting the check-out date to be the same as the check-in date using jQuery UI Date range picker (http://jqueryui.com/datepicker/#date-range). I have it where they are not able to select before the…
user1588572
  • 83
  • 1
  • 3
  • 8
0
votes
1 answer

Multidimensional Array Between Dates and Total Price

I'm trying to make PHP array and here is my example. In each array first row is unique record number "[767962]" After inside that array hotel room id 1st row. 2nd is hotel name 3rd and 4th are first price range between 5th is the price Array…
Birol Duman
  • 3
  • 3
0
votes
1 answer

How do I convert Google Scripts date range strings like "LAST_MONTH" to actual dates?

Several functions in Google Scripts for Adwords supports the following date range strings: TODAY, YESTERDAY, LAST_7_DAYS, THIS_WEEK_SUN_TODAY, LAST_WEEK, LAST_14_DAYS, LAST_30_DAYS, LAST_BUSINESS_WEEK, LAST_WEEK_SUN_SAT, THIS_MONTH, LAST_MONTH,…
Hubro
  • 56,214
  • 69
  • 228
  • 381
0
votes
2 answers

Need help with a MySQL/PHP query involving date ranges

Essentially I need to retrieve some account information from the dbase table where they have a client of the client that has been passed via GET, and the account placement date (dateplaced) is between the start and end dates passed from calendar…
DWilliams
  • 451
  • 8
  • 22
0
votes
1 answer

Year value error from PHP date()

Given a start and end date, I need to generate an array with year and week values. For example: Start Date: 2013-01-01 End Date: 2013-02-23 Generated Array: Array ( [0] => Array ( [week] => 01 [year] => 2013 ) [1] => Array ( [week] => 02 [year] =>…
Justin
  • 623
  • 1
  • 10
  • 24
0
votes
1 answer

SELECT string date rows In a Date Range using variable

Good day! I have a problem about filtering string date in date range using variable. Here's my sample query that didn't work: Select * from table_name where datee >= '" & result & "' and datee1 <= '" & result1 & "'; This code displays same date ,…
Pauline
  • 21
  • 1
  • 2
  • 10
0
votes
4 answers

Order By Minimum distance from getdate

I have this table Id_User Id_Subscription Date_Expiration 1 1 2013-01-21 1 2 2013-01-28 2 1 2013-01-15 2 2 2013-01-30 2 3 2013-01-31 I want to…
Luigi Saggese
  • 5,299
  • 3
  • 43
  • 94
0
votes
1 answer

Date range based on Date.today

I have an app which is used to calculate the paychecks of a number of employees. The paychecks are calculated from the 21st in a month to the 20th in the next month. So when the employee uses the app I need to find these two dates (start_date and…
Twiddr
  • 297
  • 1
  • 4
  • 18
0
votes
2 answers

How to set month range according to Indian financial years

According to Indian financial year(April-1 to March-31), how do i get range when month changed to January my logic fails after 31 December, nothing is displayed.Here is my code for displaying all months: Model: def self.get_month(month) …
Ravindra
  • 1,039
  • 2
  • 12
  • 26
0
votes
2 answers

how find collective range in two period in database

i have a table in database , and i want write query code to select collective date between two record . this is sample code : table is : CREATE TABLE `user` ( `userid` int(11) NOT NULL AUTO_INCREMENT, `startdate` date NOT NULL, `enddate`…
aya
  • 1,597
  • 4
  • 29
  • 59
0
votes
2 answers

How to select the record between the date range including the given date in Mysql

I need to check the date in the range from_date and to_date. Ex) Employee applies leave from 2012-11-08 to 2012-11-09, here I need to check 2012-11-08 with the date range includes the from_date and to_date. Please suggest me to use the proper…
nkdweb
  • 13
  • 1
  • 10
0
votes
1 answer

Object with starts_on and ends_on best query suggestion

I need to select from a table that has a starts_on field and an ends_on field. I need to pass start date and end date for filtering and retrieving those objects. At the moment it's working and I use the following: SELECT * FROM *** WHERE ((starts_on…
CLod
  • 917
  • 2
  • 11
  • 28
0
votes
2 answers

Validate a date range within MySQL query

(This question may seem easy or kind of noobish, by that I pardon my ignorance.) I used PDO query to use SELECT then fetch some values, it comes to a point that I need to fetch only some entries that within its start date and end date. My…
fishcracker
  • 2,401
  • 5
  • 23
  • 28
0
votes
1 answer

Get specific range from NSArray

So, I think this won't be easy ... Here goes: I have two NSArrays , each contain some custom objects (KVC compliant .. maybe this will help). The objects have two properties in the first array (lets call it array1) this objects are NSNumbers, in the…
user1028028
  • 6,323
  • 9
  • 34
  • 59
0
votes
1 answer

TSQL DateRange counting day by day

I solve the problem which counts for 1 day but when I split the days into 1 day I got problem. declare @Start datetime declare @Finish datetime declare @TimeRange int set @Start = N'2012-10-16 00:00:00.000' set @Finish =…
cihadakt
  • 3,054
  • 11
  • 37
  • 59
1 2 3
…
99
100