Date Filter

[liamloveslearning]

Hi all,

 

I have a photo gallery, in my showcase I want to show only photos uploaded this week,

 

Im currently filtering my command using BETWEEN $mystartdate AND $myenddate

<?php 
$startdate = date('Y-m-d', strtotime ("last Sunday"));
$enddate = date('Y-m-d', strtotime ("next Saturday"));



?>

 

Only when it comes to sunday it shows all photos makred to show in the future, if this makes sense? How can i filter this to say show all photos between last sunday and the sunday coming? or if its currently a sunday, show all photos uploaded between last sunday and today?

[liamloveslearning]

I think this works...

 

<?php 
$startdate = date('Y-m-d', strtotime ("last Sunday"));
$enddate = date('Y-m-d', strtotime("now"));
?>

[Alex]

$enddate = date('Y-m-d', strtotime("now"));

Would be the same as..

$enddate = date('Y-m-d');

[salathe]

Maybe I'm misunderstanding, but don't you always want the photos between last Sunday and today?