Ben SmithBen Smith
Ben Smith/
Project Period
Project Period
Project Period

Project Period

For
CivMegas168
From
Reddit
Status
Updating
Formulas
+
+
==
==
formatDate
formatDate
if
if
Share
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"))
 
By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!
By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!