I am wondering how to format a date or potentially two dates in a Text field. I have a text field that is populated with up to two dates from a pipeline automation. The dates I believe are coming in as UTC. See example below. How can I get them displaying at MM-DD-YY or something similar?
Qrew LegendThis formula will strip away the time portion of the text.
var text DateOne = Left([Coaching_pipelineText], "T");
var text DateTwo = Trim(Left(Part([Coaching_pipelineText],2, "Z"),"T"));
List("\n",
$DateOne,
$DateTwo)
Is there a way to get them side by side instead of on top of each other? Maybe something like this?
2024-05-13, 2024-03-06
Qrew LegendSure, the List function uses the specified separator string to separate the subsequent non blank strings.
So just make this change to use a comma space as the separator.
List(", ",
$DateOne,
$DateTwo)
