Search joining date similar to created in ISC

[ggregory199 (george gregory)]

I have a requirement where we want to search the joining date similar to created. Eventually a report should be created for the identities who are going to be hired 2 days from today.

We are trying to achieve this similar to created:[now TO now+2d]
but it doesnt seems to work the same for: attributes.joiningDate:[now TO now+2d]

Can someone help me out on how can i achieve this?

[neeraj99 (Neeraj Nautiyal)]

Hi @ggregory199

So in order to achieve this use case, you will have to create a attribute which should have “DateType” at the end.
Ex: joiningDateType (Techinical Name)

Once you have the attribute created like above, create a transform as well. This is to make sure that the date coming from source matches the format of now.

See the below attached Code snippet.
P.S. if you have time also coming in please update the Output format accordingly.
Reference document for date-time that sailpoint supports: SimpleDateFormat (Java Platform SE 8 )
Supporting sailpoint doc: Date Format | SailPoint Developer Community

{
	"name": "Joining Date Type Transform",
	"type": "dateFormat",
	"attributes": {
		"input": {
			"attributes": {
				"attributeName": "joiningDate",
				"sourceName": "HR"
			},
			"type": "accountAttribute"
		},
		"inputFormat": "yyyy/MM/dd'T'HH:mm:ss'Z'",
		"outputFormat": "yyyy-MM-dd"
	},
	"internal": false
}

Hope this helps…

[ggregory199 (george gregory)]

Thank you for response this works