Need help in formula for max date

[Tehmina Aslam]

Hi,

I have structure where all the tickets are grouped by assignee: I want to check when the resource is free

• I want to get the maximum date from the ticket assigned to the resource 
• if the maximum date is not passed, then it shows that the resource is free by x days 

• if the maximum date is passed yesterday, then it shows that the resource is free today

• if the maximum date is passed already, then it shows that the resource is free since x days 

WITH maxDueDate = MAX(dueDate) 
WITH currentDate = NOW()
WITH daysDifference = ROUND((currentDate - maxDueDate) / (1000 * 60 * 60 * 24))

WITH availabilityStatus = 
    IF (currentDate > maxDueDate) :
        "Free since " + daysDifference + " days"
    ELSE IF (currentDate == maxDueDate + 1 day) :
        "Free today"
    ELSE :
        "Free in " + (maxDueDate - currentDate) / (1000 * 60 * 60 * 24) + " days"

Thank in advance

[Stepan Kholodov _Tempo_]

Hello @Tehmina Aslam 

If you want to return complex values of a text combined with calculated numeric values, you can use the concat() function for it. It can be done by replacing:

"Free since " + daysDifference + " days"

with

concat("Free since ", daysDifference, " days")

I hope this helps! If you need further assistance or if you have more questions about Structure, please reach out to us directly at our support portal and we'll get back to you shortly.

Best regards,
Stepan
Tempo (the Structure app vendor)