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
2 answers

How to Update Bindings on bootstrap-daterangepicker date change?

I am using this plugin with my AngularJS app and variables to store the start and end date whenever they change. on date range change, how can i call the controller method to update data on the page? Like calling this method of the…
forsimb
  • 91
  • 1
  • 7
0
votes
1 answer

How to add date range in invoice search view and print the selected range in the report?

I added two fields for date range in account.invoice, it works fine but i am not able to print the dates in report. Here is my code: 'date_from':fields.function(lambda *a,k:{}, method=True, type='date',string="Date from"),…
user2024741
  • 9
  • 2
0
votes
2 answers

ORACLE SQL Query records where date falls between minimum and maximum date from other table

In TABLE_A there is for each ID a minimum SDT and maximum EDT. Example: for ID=1000 this will be 1/09/2013 and 3/10/2013. Example: for ID=1001 this will be 1/07/2013 and 3/08/2013. The expected result will be all records from TABLE_B where the…
user1875323
  • 137
  • 1
  • 2
  • 9
0
votes
1 answer

JavaScript: Create age based date ranges

Lets say there is one age variable and another variable for the range of the age. I already programmed this script to calculate the dates for search between, but it doesn't always calculate the correct start/end date. If I use as age 30 and range…
David
  • 560
  • 2
  • 10
  • 26
0
votes
1 answer

PHP MSSQL use "Where" to select a date range

I'm trying to populate a list menu where the selections will either be in the past or the future based on the gamedate. i want 1 menu to list games that have been played, based on the current date, and 1 menu to list games that have not been…
user2772759
  • 1
0
votes
1 answer

Date Range Search

hi im having trouble in my date range search cause it fetch wrong result ex: im searching 04/01/2013 to 04/02/2013 supposedly that the result will show the data from 04/01/2013 to 04/02/2013 these dates but it fetch it wrong data this is my…
seven
  • 115
  • 1
  • 1
  • 9
0
votes
1 answer

Thinking Sphinx without records within date range error

im trying to find records that are NOT created in a certain date range using a thinking sphinx query in my rails 4 project with postgresql as database THIS WORKS Housing.search "some text", star: true, ranker: :bm25, with: {created_at…
Nicolai
  • 321
  • 3
  • 7
0
votes
1 answer

Lucene 4.0.0 time range search

We have problems related to time range search/filter in Lucene 4.0.0. We have indexed some tweets, and now we want to collect the tweets sent by a specific user in a specific time range. When we run the related query using the created filter, we…
user2737636
  • 3
  • 1
  • 3
0
votes
1 answer

Selecting Historical Record Outside of Date Range

I have a situation where I need to select an address that was current for a particular date and time from an address history table. Some sample records might be as follows: Address/Client JOIN Table…
DerPflug
  • 97
  • 9
0
votes
1 answer

PHP SimpleXML startdate in given date range

I have problems to get all events from an XML-file with a startdate between a given date range. My XML file looks like this: 1 1375740000 …
kathi
  • 74
  • 1
  • 8
0
votes
2 answers

MySQL - Using a date range vs functions

I needed to know how many users registered during June and July, this is the first query I wrote: select count(*) from users where created_at>="2013-06-01" and created_at<="2013-07-31" Result: 15,982 select count(*) from users where…
miligraf
  • 1,042
  • 9
  • 22
0
votes
0 answers

Crystal Report: errors when using date range

I am encountering problems with some of the date ranges when using the Formula Editor from the Report->Edit Record Selection Formula screen in Crystal Report (8.2) For instance, {SomeTable.someDate} in Aged0To30Days is giving me the…
dimmy
  • 13
  • 1
  • 1
  • 5
0
votes
6 answers

Build date range

I have a start date of 20090101 and an end date of 20091130 and I'm trying to build and array of all the months in between, which would look like this:
Oliver
  • 809
  • 1
  • 11
  • 18
0
votes
2 answers

Solr Multivalued date range from two separate field as sub entity

I am a Apache Solr beginner. My data-config.xml contains this code ...
Sadat
  • 3,493
  • 2
  • 30
  • 45
0
votes
1 answer

Generate Monthly XML from a table containing date range

I have a table as - test_table(booking_id, booking_description, start_date, end_date) Sample Data - 1 | Some booking | 06/30/2013 | 08/01/2013 2 | Some new one | 08/05/2013 | 09/01/2013 3 | Some new two | 09/03/2013 | 09/05/2013 Now I want to…
codeomnitrix
  • 4,179
  • 19
  • 66
  • 102
1 2 3
…
99 100