I have a an event table SeminarPage with the date saved in format YYYY-MM-DD
If I want to select events of today I simply
$today=date('Y-m-d');
$results = DataObject::get("SeminarPage","`seminardate`='$today'");
===
Now I want to select this week
$thisweek=date('-W');
$results = DataObject::get("SeminarPage"," ....='$thisweek'");
My problem is that seminarweek is not stored in the table and should be calculated as a function of `seminardate`:
seminarweek=date('-W','`seminardate`);
I am not sure how insert this calculation into clause .
Thank you in advance
Victor