How to show date difference in record type based on condition

Question

Hi, 
 I want to display the difference between today's date and created date in record type as an integer value. Further, I want to show the value in certain colors based on condition (like if the values is less than 3 then green color; if the values are in between 3 and 5 then yellow; and if the values are greater than 5 then red). This values will only come when the status is not completed. 
 Can somebody guide me?. 
 Many thank,

balti · Accepted Answer

for color handling -> a!localVariables(
 local!data: {
 a!map(id: 1, date: todate("1/02/2024")),
 a!map(id: 2, date: todate("1/12/2024")),
 a!map(id: 3, date: todate("1/17/2024"))
 },
 {
 a!richTextDisplayField(labelPosition: "COLLAPSED", value: {
 a!forEach(
 items: local!data,
 expression: a!richTextItem(
 text: {concat(tointeger(today()-fv!item.date)," Days left"),char(10)},
 color: if(
 tointeger(today()-fv!item.date)<=3,
 "POSITIVE",
 if(
 tointeger(today()-fv!item.date)<=15,
 "STANDARD",
 "NEGATIVE"
 )
 )
 ))
 })
 }
)

balti · Answer

for geting the number of days you can use this -> tointeger(today() - todate("1/12/2024")) and based on the output you can change the color of the richtext by applying some if conditions

Konduru Chaitanya · Answer

Hello sajids0001 , You can make use of custom record fields for your use case. Have one custom record field where you find the date difference and in the other you can have your color based on the 1st custom record field. Else have only one field where you get the date difference and then based on the values you can handle the colors in UI. Coming to the condition of status you can also handle that in UI or you can create your custom field in Sync-time evaluation using the expression.

How to show date difference in record type based on condition

Top Replies