{!IF(ISBLANK(relatedTo.DaysAllowed__c),"TBD",
relatedTo.DaysAllowed__c, {!TEXT(relatedTo.DaysAllowed__c)} days, ends {!month(relatedTo.Deadline__c)}/{!day(relatedTo.Deadline__c)}/{!year(relatedTo.Deadline__c)}
3 risposte
Try this: {!
IF(
ISBLANK(relatedTo.DaysAllowed__c),
"TBD",
TEXT(relatedTo.DaysAllowed__c) + " days, ends " +
TEXT(MONTH(relatedTo.Deadline__c)) + "/" +
TEXT(DAY(relatedTo.Deadline__c)) + "/" +
TEXT(YEAR(relatedTo.Deadline__c))
)
}
