Skip to main content
Question

Formatting Date(s) in a Text Field

  • November 6, 2024
  • 0 replies
  • 114 views

Forum|alt.badge.img+9

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?

 

MarkShnierYou
Forum|alt.badge.img+24

This 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)