Range filter calendar

Range filter calendar

Escobedo97Escobedo97 Posts: 12Questions: 7Answers: 0

Example code im using: https://datatables.net/extensions/datetime/examples/integration/datatables.html
I was trying the filter with this specific dates
min date: February 12th 2010
max date: March 18th 2010
The results are 3 entries
But if i use this dates
min date: February 12th 2010
max date: March 17th 2010
The register with the date 2003/03/17 goes away from the query
How should the code look like if i want the max date to be: March 17th 2010 and that the datatable show me the data from Tatyana Fitzpatrick

This question has an accepted answers - jump to answer

Answers

  • rf1234rf1234 Posts: 2,990Questions: 87Answers: 421

    How should the code look like if i want the max date to be: March 17th 2010 and that the datatable show me the data from Tatyana Fitzpatrick

    The dates are parameters .. Do you mean hard coded?

  • Escobedo97Escobedo97 Posts: 12Questions: 7Answers: 0

    No, im talking about the range i will give an example:
    I have this 4 entries
    13/02/2022
    14/02/2022
    15/02/2022
    16/02/2022
    how can i show all 4 entries using this parameters as
    min date: 13/02/2022
    max date: 16/02/2022
    I ask this becuse with the current example code if i use those parameters it will only display:
    13/02/2022
    14/02/2022
    15/02/2022

    Basically i want that the max date parameter data get included too, because it would not be included unless i put max date like this
    max date:17/02/2022

  • rf1234rf1234 Posts: 2,990Questions: 87Answers: 421

    I ask this becuse with the current example code if i use those parameters it will only display:
    13/02/2022
    14/02/2022
    15/02/2022

    The code of the example uses <= for the comparison of the date column with the entered max date. I tried it using the date picker provided and everything worked fine.

  • colincolin Posts: 15,240Questions: 1Answers: 2,599
    Answer ✓

    This example from this thread is doing a date range search. Could you look at that, please, and see if it helps. If it's still not working for you, please can you update my example, or link to your page, so that we can see the problem.

    Cheers,

    Colin

  • Escobedo97Escobedo97 Posts: 12Questions: 7Answers: 0

    yes thanks

Sign In or Register to comment.