Transform to get difference between two dates in numeric form

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

Hi @mananbhavsar7!

Unfortunately, we don’t have the ability to do date math at the moment. I’ve asked for the dateTool Velocity functionality to be enabled for Transforms like it is for email templates and other SailPoint functionality, and DevRel is working on it, but it’s not available yet.

Your best bet would be to convert the dates to epoch time, then get the difference, and then do the math to convert that number back to days.

If you can give more detail about what Date 1 and Date 2 actually are, that may help us come up with other ideas.

-Mark

1 Like