Calendar Reporting - Selecting Date Ranges | Community
Skip to main content
Eric_D_Miller
Eric_D_Miller
Level 5
September 5, 2023
Solved

Calendar Reporting - Selecting Date Ranges

  • September 5, 2023
  • 1 reply
  • 1055 views

Hello,

 

I am currently trying to make a Calendar report, but my user has a specific date range they wish to report on. The Start Date they wish to use is tied to a specific task in the project, where as the End Date is tied to the Parent Project's Completion Date.

 

Is this possible?

 

Thank you,

Eric

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by skyehansen

it would be the same as your other calculated field but just tack a "project" in front of it. Like this:

 

{project}.{plannedCompletionDate}

 

Make sure you formatted both calculated fields as "date" and you should be good to go.

1 reply

skyehansen
Community Advisor
skyehansenCommunity Advisor
September 5, 2023

The only way I see this happening is if you create 2 custom fields on a task custom form attached to your specific task. One custom field is for the end date, and the other is for the start date. In the calendar report, you would select custom dates (https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/calendars/use-custom-dates.html?lang=en -- follow these instructions for the report) in the task area.

    Eric_D_Miller
    Eric_D_MillerAuthor
    Level 5
    September 6, 2023

    Thank you!

    I was able to create a calculated field to reference the Planned Completion Date of the task so I can report on that for my Start Date in the calendar report. That works great.

     

    Is it possible to create a calculated field that references the Parent Project's Planned Completion Date on the Task Custom Form? If that is possible that will eliminate my users from needing to drill down to the task level to input data on the custom form.

     

    Let me know if that makes sense,

    Eric

    Eric_D_Miller
    Eric_D_MillerAuthor
    Level 5
    September 6, 2023

    it would be the same as your other calculated field but just tack a "project" in front of it. Like this:

     

    {project}.{plannedCompletionDate}

     

    Make sure you formatted both calculated fields as "date" and you should be good to go.


    Amazing! That worked. Thank you 👽

    Terms & ConditionsAccessibility statement

    Loading footer...