Date formatting of String dates in email templates

Identity Security Cloud (ISC) ISC Discussion and Questions
1

Hi all,

I’m trying to format the date in the “access request” email templates. In some of these email templates, the sunset date (of “removeDate”) is included as a String argument (according to docs: Access Request Reviewer Email Template - SailPoint Identity Services). I’m having trouble with formatting these by using the Velocity template engine.

I know there is a spTools.formatDate() function that can be used to define how the date is printed in the email, but this seems to require a Date argument. So, according to the docs, I should be able to use spTools.formatDate($removeDate,"dd-MM-yyyy") to format the date from Sat Dec 17 23:00:00 UTC 2022 to 17-12-2022 but it returns nothing (blank), probably because the method expects a date.

Has anybody encountered this issue and managed to resolve it? Thanks in advance!

2

Just to add, these are some of the email templates I’m working on:

  • Access Profile Owner Approval Notification
  • Access Request Cancelled
  • Access Request Decision
  • Access Request Submitted Email For Requester After Validation