Identity search based on endDate attribute - Date format

Identity Security Cloud (ISC) ISC Discussion and Questions
,
1

Hi Team,

I need help with below search queries.

(1) If the identity’s attribute endDate is set to this ISO date format 2024-10-12T23:00:00Z, when I use this search query attributes.endDate:[now/d+1d TO now/d+1d] it returns the expected identity.

But, if the identity’s attribute endDate is set to this date format 10/12/2024 23:00:00 PM GMT, when I use the same search query attributes.endDate:[now/d+1d TO now/d+1d] it doesn’t returns the expected result or any result. I know this might be because the search only returns the result if the date is in ISO format.

Is it possible to change this date format 10/12/2024 23:00:00 PM GMT to ISO format 2024-10-12T23:00:00Z while using the search query? I know this can be done using a transform but not sure if we can do this in the search by using some logic.

(2) Like I said above, if the identity’s attribute endDate is set to this ISO format 2024-10-12T23:00:00Z, when I use this search query attributes.endDate:[now/d+1d TO now/d+1d], it does return the expected result.

But, if the identity’s attribute endDateFormatted is set to this ISO date format 2024-10-12T23:00:00Z, when I use this search query attributes.endDateFormatted:[now/d+1d TO now/d+1d], it doesn’t return the expected result or any result. That’s really weird.

Thanks

2

For Item 1: Dates can only be in ISCO8601 format (yyyy-MM-dd’T’HH:mm:ss.SSSZ or yyyy-MM-dd)

If your dates are coming in differently from your authoritative source, you can use a transform to set the data into the expected format in the standard attribute.

For Item 2: For custom date attributes, it seems like ISC only treats custom fields as dates when the last part of the technical name is “DateType”. So, in your case, you would want the technical name to be endDateFormattedDateType. See this discussion:

dateType IdentityProfile attribute issue - Identity Security Cloud (ISC) / ISC Discussion and Questions - SailPoint Developer Community

2 Likes
3

Hi @agutschow

Thanks for your help with this.

I created a custom identity attribute with suffix ‘DateType’ and it has worked perfectly i.e now it returns the expected results. :+1:

4

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.