Ok, list is now showing, but for some reason, we have double of one "SubscriptionName" and I have been trying to get it to only display the "Name" of the subscription that is in a specific date range. I have tried using ".compareTo" and "$date.difference" and it still just pulls in all those in "$interestingItems", and the first result twice as shown below as it looks in the email... A-S00013411 A-S00013411 A-S00013675
#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.AutoRenew__c.equals("1") )
#set( $void = $interestingItems.add($item) )
#if( $date.difference($calNow,$renewSubDate).getDays() <=45 )
${display.list($interestingItems,"<br>","<br>","Name")}
#else
NOPE
#end
#end
#end
#end
... View more
Customize up to 8 badges at the top of your trophy case for all other Community members to see!
Ignite 1
Earned on 2.08.21
Earned by 3327 people
Select to learn more
Give Back 5
Earned on 2.08.21
Earned by 967 people
Select to learn more
Give Back 3
Earned on 2.08.21
Earned by 1500 people
Select to learn more
Give Back 1
Earned on 2.08.21
Earned by 3314 people
Select to learn more
You're It
Earned on 2.04.20
Earned by 1872 people
Select to learn more
.png)