Thanks Sanford for the guidance we were able to build the intended logic based on your methodology.
However, the script is adding an additional space after the output. Thus, I was hoping to check if you could point out to us what might be creating the extra whitespace?
#set( $defaultTimeZone = $date.getTimeZone().getTimeZone("America/Denver") )
#set( $defaultLocale = $date.getLocale() )
#set( $calNow = $date.getCalendar() )
#set( $ret = $calNow.setTimeZone($defaultTimeZone) )
#set( $calConst = $field.in($calNow) )
#set( $renewDate = $convert.parseDate($Subscription__cList.get(0).NextRenewalDate__c,'yyyy-MM-dd') )
#set( $renewSubDate = $convert.toCalendar($renewDate) )
#set( $ISO8601DateOnly = "yyyy-MM-dd" )
#set( $ISO8601DateTime = "yyyy-MM-dd'T'HH:mm:ss" )
#set( $ISO8601DateTimeWithSpace = "yyyy-MM-dd HH:mm:ss" )
#set( $ISO8601DateTimeWithMillisUTC = "yyyy-MM-dd'T'HH:mm:ss.SSSZ" )
#set( $Subscription = $Subscription__cList.get(0).Name )
#set( $Status = $Subscription__cList.get(0).Subscription_Status__c)
#set( $AutoRenew = $Subscription__cList.get(0).AutoRenew__c)
#set( $interestingItems = [] )
#foreach( $item in $Zuora__Subscription__cList )
#if( $item.Subscription_Status__c.equals("Active") )
#if( $item.Zuora__AutoRenew__c.equals("1") )
#set( $void = $interestingItems.add($item) )
#set( $nextRenewDate = $convert.parseDate($item.Zuora__NextRenewalDate__c,'yyyy-MM-dd') )
#set( $nextRenewSubDate = $convert.toCalendar($nextRenewDate) )
#if( $date.difference($calNow,$nextRenewSubDate).getDays() == 44 )
#set( $FRIENDLY_24H_DATETIME_WITH_FRIENDLY_TZ = "dd MMMM yyyy" )
${date.format(
$FRIENDLY_24H_DATETIME_WITH_FRIENDLY_TZ,
$nextRenewSubDate
)}
#elseif( $date.difference($calNow,$nextRenewSubDate).getDays() == 13 )
#set( $FRIENDLY_24H_DATETIME_WITH_FRIENDLY_TZ = "dd MMMM yyyy" )
${date.format(
$FRIENDLY_24H_DATETIME_WITH_FRIENDLY_TZ,
$nextRenewSubDate
)}
#end
#end
#end
#end
... View more