Hi @shucch01,
Can you try creating a new Transform as below :
{
"name": "FormattedDate",
"type": "dateFormat",
"attributes": {
"inputFormat": "ISO8601",
"outputFormat": "yyyy-MM-dd"
}
}
Note - Your input format may change based on the timeZone you have specified in your AD source. So you can try out different input formats to get the desired output of yyyy-MM-dd
Once the transform is created, you can map the activeDirectoryLastLogin Identity attribute to the newly created transform.
Once you get the activeDirectoryLastLogin value in the desired format (yyyy-MM-dd), you can try it out in the search query.