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
1 answer

Total days in overlapping date range in Google Spreadsheet

A google spreadsheet example of what I am trying to achieve can be found here: https://docs.google.com/spreadsheets/d/16x_2NFSyYreBsC0hFA3UuhCGmhZc8fvqtNpVwZn9SRw/edit?usp=sharing In the above example, I am trying to find out the total number of…
user2705241
  • 49
  • 1
  • 2
  • 7
0
votes
1 answer

How can I select a substring based on day within a date range

I'm trying to create a script that calculates the expected results from a stored procedure. There are several tables related to the sp that share a BatchId. x_NonFullTimeEmployees has a StatusString column whose length is equal the the period…
Antarr Byrd
  • 24,863
  • 33
  • 100
  • 188
0
votes
2 answers

Use LINQ to convert multiple dates into ranges

I need help applying settings across a calendar year. My users are entering numerical targets into a database according to the season in a calendar. Think, apple cider will sell higher during the fall (September through November) and less during the…
Glen Ciborowski
  • 1
  • 2
0
votes
3 answers

Select all timestamps that is between range in MySQL

I'm working on a calendar like feature to a project of mine. I have a table like the following: ID | Title |Where |tri| Start | End |…
Philip G
  • 4,098
  • 2
  • 22
  • 41
0
votes
1 answer

Finding all the dates that lie between 2 input dates in c# with xml as data source

I am working on an application in asp.net with XML as data source where I am asking users to input 2 dates from 2 textboxes in the form "dd/MM" and not including the year. and I need to find all the details of the employee whose birthday lies in…
user3432560
  • 15
  • 2
0
votes
1 answer

Best way to store dates and date ranges in Yii

I have an old app that let's users insert dates so everyone knows when they will be on vacation. Up until now, they had text field where they would enter text as they like ("1.1,5.1,21.1-25.1") or whatever they want as it is simple text field. This…
Ljudotina
  • 269
  • 1
  • 3
  • 14
0
votes
0 answers

Number days in a Date Range

So in PL/SQL, how do I can I number the days in a date range in a select statement? I want my results to be something like: DAY | calc_field1 | calc_field1 |etc 1 | XXX | YYY |etc 2 | XXX | YYY |etc 3 | XXX …
user1435866
  • 51
  • 1
  • 5
0
votes
2 answers

How to add multiple values based on a date range displayed per day

I have the following two tables. The first is a set of date ranges with three values assigned to each date range. Start Date End Date A Hours B Hours C Hours 1/1/2014 1/10/2014 5 10 0 1/2/2014 1/5/2014 10 …
Tomoda
  • 3
  • 1
0
votes
2 answers

MySQL - Exclude conflicting date ranges

Imagine this list of date ranges > SELECT * FROM range_table; +----+------------+------------+ | id | start | end | +----+------------+------------+ | 1 | 2014-01-01 | 2014-01-15 | /* -- Not conflicting */ | 2 | 2014-01-15 | 2014-01-16…
Pierre de LESPINAY
  • 44,700
  • 57
  • 210
  • 307
0
votes
1 answer

rails3 custom validation overlapping dates error

Building a validator that has to check multiple siblings who belong to the same (option) parent. class Optionrate < ActiveRecord::Base belongs_to :option attr_accessible :from, :to, :option_id validates_presence_of :from, :to validate…
Jerome
  • 5,583
  • 3
  • 33
  • 76
0
votes
1 answer

SQL to Find records where result is in range between two columns, but check multiple rows

I'm working with two datasets, one is a more detailed view of clock punch activity, and another is a summation of entire "shifts" that these clock punches make up. What we are trying to accomplish, is to return a record where the PAYCODEID is equal…
aohm1989
  • 401
  • 1
  • 8
  • 19
0
votes
2 answers

Store multiple ranges in mysql table to make queries faster/easier

I have a data with multiple time ranges, for e.g. consider following columns | from1 | to1 | from2 | to2 | from3 | to3 | | 06:00 | 07:30 | 09:30 | 12:30 | 13:30 | 15:45 | | 05:00 | 06:30 | 08:15 | 14:40 | 16:30 | 18:25 | Now if I want to…
Salman
  • 9,299
  • 6
  • 40
  • 73
0
votes
2 answers

SQL WITH CLAUSE for DATERANGE Select

I not sure is this correct, anyone can guide me on this. I trying to retrieve my number of guest sign in per day for a period of 1 month but there bound to some empty count where no one sign in. So the result will be like DATE | …
user2378645
  • 15
  • 4
0
votes
1 answer

jQuery Range Slider - saving date range

Hope this is not a duplicate because i didn't find question like this. I'm using jQRangeSlider for date range. The slider works showing min and max date and changing as i move it. I want to pull the date and save it into MySQL database. I need the…
user2788086
  • 61
  • 8
0
votes
3 answers

PHP MYSQL select * with this value with between these dates

I'm trying to select a list of customers that have entered a specific voucher code, within certain dates. Here is my code with my latest attempt: $result = mysql_query( "SELECT COUNT(members.voucher_code) FROM members WHERE…
Connor
  • 3
  • 3
1 2 3
…
99 100