Can't query using date

[amiriskander]

I wanted to query on rows created in a time range between two dates, but I'm having a problem querying on the createdAt field.

I wanted to know the right way to query using a date.

Thanks.

[fincom]

Hi,

Date fields are not string, it's an object.

For example, you can do query like this:
$query->whereLessThanOrEqualTo('date_start', array("__type"=>"Date","iso"=>date('Y-m-d\Th:i:s')));

That's work, but perhaps need to create specific where for Date Object.

Hope this help,

[amiriskander]

Hi,
Thanks for your reply,
I have found a commit for a contributor with a function "whereBetweenOrEqualTo" which queries rows in between two date objects.

public function whereBetweenOrEqualTo($key, $startValue, $endValue){
if(isset($key) && isset($startValue) && isset($endValue)){
$this->_query[$key] = array(
'$gte' => $startValue,
'$lte' => $endValue
);
}
else{
$this->throwError('the $key, $startValue and $endValue parameters must be set when setting a "where" query method');
}
}

But I still need to have to query on the createdAt field which is of type DateTime using just a date not a datetime.

[fincom]

public function whereBetweenOrEqualDates($key, $startDate, $endDate){
if(isset($key) && isset($startDate) && isset($endDate)){
$this->_query[$key] = array(
'$gte' => $startDate,
'$lte' => $endDate
);
}

call him for created_at without time:
$startDate = array("__type"=>"Date","iso"=>date('Y-m-d\T0:0:0');
$endDate = array("__type"=>"Date","iso"=>date('Y-m-d\T0:0:0');
$query->whereBetweenOrEqualDates("createdAt", $startDate, $endDate);

It's dirty but it should work.

[codepolariz]

Hello, i tried your code but it does not work. I returns all the data in my parse table without filtering the record