Skip to main content
New Participant
April 27, 2020
Question

Filter for Date Range on Timesheet Report

  • April 27, 2020
  • 5 replies
  • 1011 views

Hi folks,

Does anyone know how to use text mode and put a filter on the Date Range field? The Date Range field is a text mode field available in WF's off the shelf report 'All Open Timesheets'. I'd like to create a copy of this report and put a filter on it to only show data based on a Date Range of $$TODAY-4w (the last 4 weeks of timesheets). Since this field is only available in text mode, from what I can see, does anyone know how to do a text mode filer for the above date range (4 weeks)?

Here's the text mode for the Date Range field:

link.linkproperty.0.name=ID

link.linkproperty.0.valuefield=ID

link.linkproperty.0.valueformat=val

link.page=/timesheetOpenTime.cmd

link.valuefield=objCode

listsort=atDateAsAtDate(startDate)

namekey=daterange

querysort=startDate

sortOrder=1

sortType=desc

textmode=true

valueexpression=CONCAT(DATENOTIME({startDate}),' - ',DATENOTIME({endDate}))

valueformat=val

width=80

Thanks.

Nick

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

5 replies

NickVa7Author
New Participant
May 27, 2020

Nothing, sorry, Jen.

New Participant
May 27, 2020

Hey @Nick Valeriote‚ - did you find a solution? I'm hitting the same problem on my end.

Thanks,

-Jennifer

NickVa7Author
New Participant
April 28, 2020

Thanks for the response, Ryan. Yeah, I had originally tried that (start date), and it didn't seem to capture timesheets further than 2-3 weeks back. I even upped it to $$TODAY-50w and it still didn't capture anything further than 2-3 weeks. I thought that was odd.

New Participant
April 28, 2020

That was my best guess, sorry Nick.

New Participant
April 28, 2020

Would using the Filter tab when editing the report, and filtering based off Timesheet Start or End Date Work? Maybe Timesheet Start Date > Less Than $$TODAY-4w?