Formatting time variables in Substitution Keywords

It seems you're close, but you're using the 12-hour format (hh:mm) in your $date.format function. To resolve this and either specify the 24-hour clock or add an AM/PM label in IFS Assyst, you can adjust the format string to suit your needs:

1. For a 24-hour clock: Use HH:mm instead of hh:mm. The HH represents the hour in 24-hour format.

   Copiar código

   $date.format('HH:mm', $new.event.W("DATETIME"))

   This will return 23:00 for 11 PM.

2. For a 12-hour clock with AM/PM: You can add an AM/PM suffix by using a in the format string.

   Copiar código

   $date.format('hh:mm a', $new.event.W("DATETIME"))

   This will return 11:00 PM or 11:00 AM as appropriate.

Perfect. Thanks very much for your help.