Hi there,

When I search Activity with API with criteria like idProject and IdUser, like this :

$sql =" idProject ='5'and name='Congé Annuel'and idUser='28'";
$search_presence_activity= urlencode($sql);

it's OK, I get a result like this  : 

object(stdClass)[23]
  public 'identifier' => string 'id' (length=2)
  public 'items' => 
    array (size=13)
      0 => 
        object(stdClass)[176]
          public 'id' => string '275' (length=3)
          public 'reference' => string '-TAS-150' (length=8)
          public 'name' => string 'Congé Annuel' (length=13)
          public 'idActivityType' => string '26' (length=2)
          public 'nameActivityType' => string 'Tâche' (length=6)
          public 'idProject' => string '5' (length=1)
          public 'nameProject' => string 'Absences' (length=8)
          public 'externalReference' => string '' (length=0)
          public 'creationDate' => string '2022-06-23' (length=10)
          public 'lastUpdateDateTime' => string '2022-06-23 11:40:02' (length=19)
          public 'idUser' => string '28' (length=2)
          public 'nameUser' => string 'NOE Alexandre' (length=13)
          public 'idContact' => string '' (length=0)
          public 'nameContact' => string '' (length=0)
          public 'originType' => string '' (length=0)
          public 'originId' => string '' (length=0)
          public 'refName' => string 'Congé Annuel' (length=13)
          public 'description' => string '' (length=0)
          public 'idActivity' => string '' (length=0)
          public 'nameActivity' => string '' (length=0)
          public 'idStatus' => string '1' (length=1)
          public 'nameStatus' => string 'enregistré' (length=11)
          public 'idResource' => string '28' (length=2)
          public 'nameResource' => string 'NOE Alexandre' (length=13)
          public 'idMilestone' => string '' (length=0)
          public 'nameMilestone' => string '' (length=0)
          public 'fixPlanning' => string '0' (length=1)
          public 'paused' => string '0' (length=1)
          public 'handled' => string '0' (length=1)
          public 'handledDate' => string '' (length=0)
          public 'done' => string '0' (length=1)
          public 'doneDate' => string '' (length=0)
          public 'idle' => string '0' (length=1)
          public 'idleDate' => string '' (length=0)
          public 'cancelled' => string '0' (length=1)
          public 'result' => string '' (length=0)
          public 'validatedStartDate' => string '2022-06-20' (length=10)
          public 'plannedStartDate' => string '' (length=0)
          public 'realStartDate' => string '' (length=0)
          public 'initialStartDate' => string '' (length=0)
          public 'validatedEndDate' => string '2022-07-01' (length=1

But when I add a date criteria like "validatedStartDate" in my search criteria like this: 

$sql ="idProject ='5'and name='Congé Annuel'and idUser='28' and validatedStartDate = '2022-06-20'";

The result is empty. Why ??  Normally, I sould obtain the same résult because it's the same date as before ! 

How to obtain my activities with date criteria, please ? 
Is it possible to search activity with validated start and end date ? 
Maybe I'm doing it wrong ? 

Thank you so much in advance,

Florian