How to check if a date is in a given range

Question

If you have a  start date and  end date  how can you check if a date given by the user falls within that range   e g    start date    2009-06-17     end date    2009-09-05     date from user    2009-08-28      At the moment the dates are strings  would it help to convert them to timestamp integers

User · Answer

In the format you ve provided  assuming the user is smart enough to give you valid dates  you don t need to convert to a date first  you can compare them as strings

User · Answer

startDatedt   strtotime  start date   endDatedt   strtotime  end date   usrDatedt   strtotime  date from user   if   usrDatedt  gt    startDatedt  amp  amp   usrDatedt  lt    endDatedt           falls within range

User · Answer

You can try this     custom date for example  d1   new DateTime  2012-07-08     d2   new DateTime  2012-07-11     d3   new DateTime  2012-07-08     d4   new DateTime  2012-07-15       create a date period object  interval   new DateInterval  P1D     daterange   iterator to array new DatePeriod  d1   interval   d2     daterange1   iterator to array new DatePeriod  d3   interval   d4    array map function  v  use   daterange1    if in array  v   daterange1   print  Bingo       daterange

User · Answer

Convert them into dates or timestamp integers and then just check of  date from user is  lt    end date and     start date

User · Answer

Convert both dates to timestamps then do   pseudocode   if date from user  gt  start date  amp  amp  date from user  lt  end date     return true

User · Answer

Use the DateTime class if you have PHP 5 3   Easier to use  better functionality   DateTime internally supports timezones  with the other solutions is up to you to handle that    lt  php             param DateTime  date Date that is to be checked if it falls between  startDate and  endDate     param DateTime  startDate Date should be after this date to return true     param DateTime  endDate Date should be before this date to return true    return bool     function isDateBetweenDates DateTime  date  DateTime  startDate  DateTime  endDate        return  date  gt   startDate  amp  amp   date  lt   endDate      fromUser   new DateTime  2012-03-01     startDate   new DateTime  2012-02-01 00 00 00     endDate   new DateTime  2012-04-30 23 59 59     echo isDateBetweenDates  fromUser   startDate   endDate

User · Answer

Converting them to timestamps is the way to go alright  using strtotime  e g    start date    2009-06-17     end date    2009-09-05     date from user    2009-08-28    check in range  start date   end date   date from user     function check in range  start date   end date   date from user         Convert to timestamp    start ts   strtotime  start date      end ts   strtotime  end date      user ts   strtotime  date from user         Check that user date is between start  amp  end   return    user ts  gt    start ts   amp  amp    user ts  lt    end ts

User · Answer

It s not necessary to convert to timestamp to do the comparison  given that the strings are validated as dates in  YYYY-MM-DD  canonical format   This test will work        date from user  gt    start date    amp  amp     date from user  lt    end date       given    start date        2009-06-17    end date          2009-09-05    date from user    2009-08-28     NOTE  Comparing strings like this does allow for  non-valid  dates e g   December 32nd    2009-13-32  and for weirdly formatted strings  2009 3 3   such that a string comparison will NOT be equivalent to a date or timestamp comparison   This works ONLY if the date values in the strings are in a CONSISTENT and CANONICAL format   EDIT to add a note here  elaborating on the obvious   By CONSISTENT  I mean for example that the strings being compared must be in identical format  the month must always be two characters  the day must always be two characters  and the separator character must always be a dash  We can t reliably compare  strings  that aren t four character year  two character month  two character day  If we had a mix of one character and two character months in the strings  for example  we d get unexpected result when we compared   2009-9-30  to  2009-10-11    We humanly see  9  as being less than  10   but a string comparison will see  2009-9  as greater than  2009-1    We don t necessarily need to have a dash separator characters  we could just as reliably compare strings in  YYYYMMDD  format  if there is a separator character  it has to always be there and always be the same     By CANONICAL  I mean that a format that will result in strings that will be sorted in date order  That is  the string will have a representation of  year  first  then  month   then  day   We can t reliably compare strings in  MM-DD-YYYY  format  because that s not canonical  A string comparison would compare the MM  month  before it compared YYYY  year  since the string comparison works from left to right   A big benefit of the  YYYY-MM-DD  string format is that it is canonical  dates represented in this format can reliably be compared as strings    ADDENDUM   If you do go for the php timestamp conversion  be aware of the limitations   On some platforms  php does not support timestamp values earlier than 1970-01-01 and or later than 2038-01-19    That s the nature of the unix timestamp 32-bit integer    Later versions pf php  5 3   are supposed to address that   The timezone can also be an issue  if you aren t careful to use the same timezone when converting from string to timestamp and from timestamp back to string   HTH

User · Answer

start date  17 02 2012    end date  21 02 2012    date from user  19 02 2012    function geraTimestamp  data         partes   explode       data        return mktime 0  0  0   partes 1    partes 0    partes 2         startDatedt   geraTimestamp  start date     endDatedt   geraTimestamp  end date    usrDatedt   geraTimestamp  date from user    if    usrDatedt  gt    startDatedt   amp  amp    usrDatedt  lt    endDatedt          echo  Dentro         else       echo  Fora

User · Answer

I found this method the easiest    start date    2009-06-17    end date    2009-09-05    date from user    2009-08-28     start date   date create  start date    date from user   date create  date from user    end date   date create  end date     interval1   date diff  start date   date from user    interval2   date diff  end date   date from user    if  interval1- gt invert    0     if  interval2- gt invert    1            if it lies between start date and end date execute this code

[php] How to check if a date is in a given range?

Examples related to php

Examples related to date

Examples related to date-range