<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: How do I create a custom report column that shows the duration of the project from its Actual Start to today? in Workfront Questions</title>
    <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/how-do-i-create-a-custom-report-column-that-shows-the-duration/m-p/486162#M18820</link>
    <description>&lt;P&gt;Teale,&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;That works, thank you so much! &lt;/P&gt;</description>
    <pubDate>Tue, 05 Jan 2021 13:45:00 GMT</pubDate>
    <dc:creator>SarahMe2</dc:creator>
    <dc:date>2021-01-05T13:45:00Z</dc:date>
    <item>
      <title>How do I create a custom report column that shows the duration of the project from its Actual Start to today?</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/how-do-i-create-a-custom-report-column-that-shows-the-duration/m-p/486160#M18818</link>
      <description>&lt;P&gt;Hi all and Happy New Year!&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;I'm trying to create a custom column in a report that will show the number of days since the Actual Start Date for any project in Current status. For example, if the Actual Start Date of a project is 01/01/21 and today is 01/04/21, the column would say "3". I haven't been able to find a direct term for this type of duration (although it may exist) so I'm thinking it will need to be in text mode. &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Any help would be greatly appreciated, thanks in advance!&lt;/P&gt;</description>
      <pubDate>Mon, 04 Jan 2021 14:46:49 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/how-do-i-create-a-custom-report-column-that-shows-the-duration/m-p/486160#M18818</guid>
      <dc:creator>SarahMe2</dc:creator>
      <dc:date>2021-01-04T14:46:49Z</dc:date>
    </item>
    <item>
      <title>Re: How do I create a custom report column that shows the duration of the project from its Actual Start to today?</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/how-do-i-create-a-custom-report-column-that-shows-the-duration/m-p/486161#M18819</link>
      <description>&lt;P&gt;Hi Sarah, &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Try this:&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;valueexpression=CONCAT(ROUND(DATEDIFF({actualStartDate},$$TODAY),2)," Days")&lt;/P&gt;&lt;P&gt;valuefield=actualStartDate&lt;/P&gt;&lt;P&gt;linkedname=direct&lt;/P&gt;&lt;P&gt;valueformat=HTML&lt;/P&gt;&lt;P&gt;aggregator.valueexpression=CONCAT(ROUND(DATEDIFF({actualStartDate},$$TODAY),2)," Days")&lt;/P&gt;&lt;P&gt;aggregator.function=SUM&lt;/P&gt;&lt;P&gt;aggregator.valueformat=HTML&lt;/P&gt;&lt;P&gt;aggregator.displayformat=HTML&lt;/P&gt;&lt;P&gt;displayname=&lt;/P&gt;&lt;P&gt;namekey=$$TODAY&lt;/P&gt;&lt;P&gt;textmode=true&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;The result will depend on the time in the actual start date field compared to the time of day when you run the report. &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Hope this helps,&lt;/P&gt;&lt;P&gt;Teale&lt;/P&gt;&lt;P&gt; &lt;/P&gt;</description>
      <pubDate>Mon, 04 Jan 2021 21:55:06 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/how-do-i-create-a-custom-report-column-that-shows-the-duration/m-p/486161#M18819</guid>
      <dc:creator>TealeMcCleaf</dc:creator>
      <dc:date>2021-01-04T21:55:06Z</dc:date>
    </item>
    <item>
      <title>Re: How do I create a custom report column that shows the duration of the project from its Actual Start to today?</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/how-do-i-create-a-custom-report-column-that-shows-the-duration/m-p/486162#M18820</link>
      <description>&lt;P&gt;Teale,&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;That works, thank you so much! &lt;/P&gt;</description>
      <pubDate>Tue, 05 Jan 2021 13:45:00 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/how-do-i-create-a-custom-report-column-that-shows-the-duration/m-p/486162#M18820</guid>
      <dc:creator>SarahMe2</dc:creator>
      <dc:date>2021-01-05T13:45:00Z</dc:date>
    </item>
  </channel>
</rss>

