Hi all,
Sorry. I made earlier an topic about this issuse but i can't find it anymore. But I've got the following issue.
I had a last list with dates which start on 20-16-17.. this list grows evertyday.
But when i want to go view this list it starts from the beginnen. Whith the code beneath (thanx Bob) i can reduce the list to THISMONTH.. But is not exactly what I need... With this code i can't view the list after thismonth... So I need something else.. I like to change it in that i want to see the list from this day (TODAY()) and further..
But I don't understand the code enough to change it in my own.. So I need a little help.. I thought that a simple change the code MONTH(NOW()) in TODAY() works.. but isnt...
Sorry. I made earlier an topic about this issuse but i can't find it anymore. But I've got the following issue.
I had a last list with dates which start on 20-16-17.. this list grows evertyday.
But when i want to go view this list it starts from the beginnen. Whith the code beneath (thanx Bob) i can reduce the list to THISMONTH.. But is not exactly what I need... With this code i can't view the list after thismonth... So I need something else.. I like to change it in that i want to see the list from this day (TODAY()) and further..
But I don't understand the code enough to change it in my own.. So I need a little help.. I thought that a simple change the code MONTH(NOW()) in TODAY() works.. but isnt...
<?php
setlocale(LC_TIME, "nl_NL");
?>
<?php
return array(":YEAR(`datum`) = YEAR(NOW()) && MONTH(`datum`) = MONTH(NOW())");
?>
Hi,
Did you try
Best regards,
Max
Did you try
DAY(`datum`) = DAY(NOW())
?
Best regards,
Max
Hi Max,
thnx for your response... when i use your give code.. it only works when i used as:
<?php
return array(":YEAR(`datum`) = YEAR(NOW()) && DAY(`datum`) = DAY(NOW())");
?>
But when i aply.. then this results that this day.... returns in de date in every month..
thnx for your response... when i use your give code.. it only works when i used as:
<?php
return array(":YEAR(`datum`) = YEAR(NOW()) && DAY(`datum`) = DAY(NOW())");
?>
But when i aply.. then this results that this day.... returns in de date in every month..

Max.... thnx for your answer....
you pushed me in the richt direction with your answer..
With the code
<?php
return array(":YEAR(`datum`) = YEAR(NOW()) && MONTH(`datum`) >= MONTH(NOW()) && DAY(`datum`) >= DAY(NOW())");
?>
get i the list that i want....
tnx again..
case closed :-)
you pushed me in the richt direction with your answer..
With the code
<?php
return array(":YEAR(`datum`) = YEAR(NOW()) && MONTH(`datum`) >= MONTH(NOW()) && DAY(`datum`) >= DAY(NOW())");
?>
get i the list that i want....
tnx again..
case closed :-)
This topic is locked and no more replies can be posted.