Projects

Action Items

Project Period

(prop("Min Date") == prop("Max Date")) ? formatDate(prop("Min Date"), "MMM DD, YYYY") : (formatDate(prop("Min Date"), "MMM DD, YYYY") + " – " + formatDate(prop("Max Date"), "MMM DD, YYYY"))

(prop("Min Date") == prop("Max Date"))

Check to see if Min Date and Max Date are the same.

? formatDate(prop("Min Date"), "MMM DD, YYYY")

If they are, display just the Min Date.

: (formatDate(prop("Min Date"), "MMM DD, YYYY") + " – " + formatDate(prop("Max Date"), "MMM DD, YYYY")) :

If they're not, display the formatted Min Date and Max Date with an en dash in between.

Start

start(prop("Period"))

End

end(prop("Period"))

<aside> <img src="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" alt="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" width="40px" /> By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!

</aside>