I have 3 custom created dateTime type fields in my Azure AD B2C solution, named
- signInDateTime
- StatusChangeDate
- ApplicationDate
I have a requirement to query the set of users based on the signInDateTime being older than 12 months.
The graph api query I have been working with is
https://graph.microsoft.com/v1.0/users?$top=999&&$filter=userType eq 'Member' and creationType eq 'LocalAccount' and extension_924********86f83d_signInDateTime le '2023-05-20T07:53:15.5623696Z'&$select=givenName,id,surname,extension_924544bbee7e4c94b3d9a00eca86f83d_emailCopy,extension_924**********83d_ApplicationDate, extension_92454************d_signInDateTime
However the request just returns all the available user records ignoring the date time based filter completely.
The same behaviour is observed when trying to filter based on ApplicationDate.
I verified the data type of the attributes and it is of dateTime type.
what could I be doing wrong here?