Topics help categorize Community content and increase your ability to discover relevant content.
This response is from 2018 - any new update on getting this to work in Classic Mode? I need to do this same report to show my managers how often their people are working on weekends. I'm really surprised that Workfront doesn't allow for this function - we would always want to know about overtime or days worked. Thank you!
Also - would you create this as a report filter? I'm trying to enter this as text mode for a new filter and it isn't working. Thank you!
ntryDate between $$TODAYbw and $$TODAYbw+24h OR entryDate between $$TODAYbw+6d and $$TODAYbw+7d OR entryDate between $$TODAYbw-7d and $$TODAYbw-6dh OR entryDate between $$TODAYbw-1d and $$TODAYbw OR entryDate between $$TODAYbw-14d and $$TODAYbw-13dh OR entryDate between $$TODAYbw-8d and $$TODAYbw-7d OR
To confirm, this approach was indeed a report filter (in classic), but from what you pasted, I suspect you might have missed an "e" and added an "OR", so invite you to try this:
entryDate between $$TODAYbw and $$TODAYbw+24h OR entryDate between $$TODAYbw+6d and $$TODAYbw+7d OR entryDate between $$TODAYbw-7d and $$TODAYbw-6dh OR entryDate between $$TODAYbw-1d and $$TODAYbw OR entryDate between $$TODAYbw-14d and $$TODAYbw-13dh OR entryDate between $$TODAYbw-8d and $$TODAYbw-7d
Thank you so much Doug! I did try this as a filter - but it still shows me all days, not just Saturday and Sunday. I've attached a snapshot picture of my filter - can you take a look and see if you can spot an issue? Thank you so much!!!!
I suspect the difference is that in the filter I'd suggested originally to Eric, the entryDate refers to each Hour that was entered (and finding only those entered on weekends), but in your filter, you're using the End Date of the Time Sheet upon into which such Hours are entered....which, suspecting your Time Sheets normally end on a weekend, is then returning all days. Instead, I'd suggest you switch to an Hours report and use entryDate; noting that you could (and by could, I really mean "would have to") then also repeat your top criteria in every OR clause to ensure it is always enforced.
@Matt Thomas‚ in case you'd like to elaborate, I suspect the latter point could illustrate how the concept of the indented "Rule Sets" (pardon me if I've got the name wrong) you and your team are designing in New Reporting Experience could make this type of filter easier to construct.
@Doug Den Hoed‚ You are exactly correct the rule set feature in New Reporting Experience would make it so you do not have to repeat the top criteria and also make it easier to "read" what the filter is actually doing. Thanks for another clear example of why this functionality is needed.
Thank you again for all your help! I created a new "hours" report with only the filters for "end date" that you provided. When I complete the prompt for the managers name and hit enter, I get all days worth of work unfortunately. See attached. I'm not sure why this isn't working for me. Ugh.
I'm assuming you meant "entryDate" (on each Hour entry) rather than "end date" (of a Timesheet), but to be sure, invite you to copy and paste your filter here, and to send full screenshots of a) your Prompt, b) the report results with no Prompt, and c) the report results with a Manager's name selected (provided, of course, that Manager is correctly set up with subordinates who have hours entered that then ought to appear).