Calculated field formula

[Ainzo992]

Guys,

I have this formula now: 

"style": {

"color": "=if([$Modified] > [$Publicationdate], '#ff0000', '')",

"font-weight": "=if([$Modified] > [$Publicationdate], 'bold', '')"

}

I want to add 15 minutes to publicationdate, so it should be modiefied + publicationdate+15 minutes 

How can i achieve this?

[#2 · Accepted solution]

@Ainzo992 You can use addMinutes() operator to add minutes to date. Try using expressions in this format: 

"style": {
    "color": "=if([$Modified] > addMinutes([$Publicationdate], 15), '#ff0000', '')",
    "font-weight": "=if([$Modified] > addMinutes([$Publicationdate], 15), 'bold', '')"
}

Documentation: json-formatting-syntax-reference  

---

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.