TruncateTime not actually removing the time - just zeros it

Screenshot here:  https://ibb.co/0yShhLb

TruncateTime() is a Microsoft built-in method that removes the time component, which it is doing.

However it does not affect the display method, so it will default to a standard date-time format, similar to how a .NET DateTime.UtcNow.Date command still returns a DateTime object with just the time zeroed out.

You need to add code to display just the date part that you want to show.

I would do that using XSLT instead. Our standard reports already do this:

<xsl:template name="format-date">
    <xsl:param name="datetime"/>
    <xsl:variable name="date" select="substring-before($datetime, 'T')" />
    <xsl:variable name="year" select="substring-before($date, '-')" />
    <xsl:variable name="month" select="substring-before(substring-after($date, '-'), '-')" />
    <xsl:variable name="day" select="substring-after(substring-after($date, '-'), '-')" />
    <xsl:variable name="time" select="substring-before(substring-after($datetime, 'T'), '.')" />
    <xsl:variable name="monthname">
      <xsl:choose>
        <xsl:when test="$month='01'">
          <xsl:value-of select="'Jan'"/>
        </xsl:when>
        <xsl:when test="$month='02'">
          <xsl:value-of select="'Feb'"/>
        </xsl:when>
        <xsl:when test="$month='03'">
          <xsl:value-of select="'Mar'"/>
        </xsl:when>
        <xsl:when test="$month='04'">
          <xsl:value-of select="'Apr'"/>
        </xsl:when>
        <xsl:when test="$month='05'">
          <xsl:value-of select="'May'"/>
        </xsl:when>
        <xsl:when test="$month='06'">
          <xsl:value-of select="'Jun'"/>
        </xsl:when>
        <xsl:when test="$month='07'">
          <xsl:value-of select="'Jul'"/>
        </xsl:when>
        <xsl:when test="$month='08'">
          <xsl:value-of select="'Aug'"/>
        </xsl:when>
        <xsl:when test="$month='09'">
          <xsl:value-of select="'Sep'"/>
        </xsl:when>
        <xsl:when test="$month='10'">
          <xsl:value-of select="'Oct'"/>
        </xsl:when>
        <xsl:when test="$month='11'">
          <xsl:value-of select="'Nov'"/>
        </xsl:when>
        <xsl:when test="$month='12'">
          <xsl:value-of select="'Dec'"/>
        </xsl:when>
        <xsl:otherwise>
          <xsl:value-of select="''" />
        </xsl:otherwise>
      </xsl:choose>
    </xsl:variable>
    <xsl:value-of select="concat($day, '-' ,$monthname, '-', $year , ' ', $time)" />
  </xsl:template>

which you call using:

                  <xsl:call-template name="format-date">
                    <xsl:with-param name="datetime" select="UpdateDate" />
                  </xsl:call-template>

I'm doing a graph not a report.  I don't see any options for adding xslt to a custom graph so I'm assuming you cannot add this to a graph... only a report?

Sorry yes that is true.

You'd need to use ESQL functions then:

https://spiradoc.inflectra.com/Reporting/Custom-Graph-Tutorial/#differences-in-literals-and-types

https://spiradoc.inflectra.com/Reporting/Custom-Graph-Tutorial/#1-requirements-addedremoved-over-time

https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/ef/language-reference/date-and-time-canonical-functions

• Day(expression)
• Month
• Year

That way you can create a string format of your choosing.

Thank you for this additional info.  Will try tweaking this in some other ways to get the string I want,  but could possibly change to using an aggregated date range as well as a second option.