Hi SailPoint Community, I am facing an issue with Identity Search range queries on a custom identity attribute called lastLoginValue. Background I have created an identity attribute named lastLoginValue using a transform that determines the most recent login across multiple sources (Entra ID, Acti…

I agree with @zachm117 - the dateType suffix will give you the behavior you are looking for. So you should have lastLoginValueDateType for the technical name, Last Login Value Date Type for the display name. Your search will be: attributes.lastLoginValueDateType:[now-60d TO now]

Just chiming in to also say that @zachm117 ’s answer is the correct solution. Please don’t forget to mark it as such, @VasanthRam .

[Screenshot 2026-08-17 at 6.34.01 PM] [Screenshot 2026-08-17 at 6.37.03 PM] [Screenshot 2026-08-17 at 6.34.15 PM]

@zachm117 Thank you for your response. Adding the suffix DateType didn’t help. Am I missing something here? Kindly provide your inputs.

Double check your search syntax. attributes.lastLoginValueDateType:now is going to have to match exactly now, the current date and time. Not likely to return any results ever. attributes.lastLoginValueDateType:[now-100 TO now]is also incorrect, and will probably tell you it’s a bad syntax. The 100 …

One more detail: make sure your identity attribute is going through a dateFormat transform to apply ISO8601 outputFormat, just to ensure that the value matches what the value of now will look like.

Thank you so much for you response. It worked!

Identity Search Range Queries Not Working on Custom Date Identity Attribute (lastLoginValue) Although ISO8601 Format Is Populated

Identity Security Cloud (ISC) ISC Discussion and Questions

zachm117 (Zach Mullins) August 14, 2026, 2:09pm 2

Hi @VasanthRam !

You need to add “dateType” to the end of your identity attribute name to force ISC to treat it as a date/time value. You can find more info about this behavior in this post.

Please let me know if this helps!

Zach

Topic		Replies	Views
Unable to perform date logic in custom identity attribute search ISC Discussion and Questions identity-security-cloud , search	4	1258	April 5, 2024
Unable to search Custom Identity Attribute in Search Query even after making it Searchable ISC Discussion and Questions transforms , identity-security-cloud	16	1120	April 11, 2024
Help - Trying to Get Last Sign in Date and then use it in Search ISC Discussion and Questions transforms , identity-security-cloud	11	237	September 12, 2025
Identitiy search based on end date attribute ISC Discussion and Questions identity-security-cloud , search	7	427	October 31, 2024
Identity search based on endDate attribute - Date format ISC Discussion and Questions identity-security-cloud , search	2	575	October 14, 2024

Identity Search Range Queries Not Working on Custom Date Identity Attribute (lastLoginValue) Although ISO8601 Format Is Populated

Related topics