Skip to main content
Question

How do you filter [Labor Date] Field for current week. What does that report formula look like?

  • March 7, 2019
  • 0 replies
  • 22 views

Forum|alt.badge.img+8
Greetings:

I am producing a User Specific Time Sheet.  Just trying to only display (filter report) and sub total [Labor Date] for current week only.

Any help is always appreciated.

Dirk

No problem. Just make a filter where the time sheet date is During the current week. The �During� should be a choice on the report filter.

Forum|alt.badge.img+8
  • Author
  • Registered
  • March 7, 2019
Is there some example of syntax I can refer to?



Are you making a filter on a report?  if so there is no syntax, it's just drop downs on the filters for the report.  Or are you making a formula field?


Forum|alt.badge.img+8
  • Author
  • Registered
  • March 7, 2019
Dan:

Oh for crying out loud!  I found it.  Just a navigation issue on my part.

Thank you,

Dirk

Forum|alt.badge.img+8
  • Author
  • Registered
  • March 8, 2019


Hey Dan:

Here is the filter setting I have used.  Either filter parameter will work, but they do not function when together (no records display).

I was hoping the individual user could see his/her hours for that week.

Dirk