Date format is not working with where method about airtable-php HOT 2 CLOSED

Implemented in v0.4.0

Please check out documentation - https://github.com/eugenezadorin/airtable-php#date-filtering

from airtable-php.

Hi! Sorry for the long wait. Your query actually converts into formula like this: {Deadline}='2022-04-02'.

Looks like Airtable don't support such comparisons and we have to use datetime functions to compare values properly.

I found following workaround for you:

$dataFDU = $client->table($tableName)
    ->select('*')
    ->whereRaw("IS_SAME(Deadline, '2022-04-02')") // using raw formula here
    ->execute();

It's temporary solution, but I will do some research and probably implement something more convenient, like that:

$query->whereDate('Deadline', '2022-04-02');

from airtable-php.