Forum Discussion

DirkRuana's avatar
DirkRuana
Qrew Captain
7 years ago

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

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.
  • 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?

  • Dan:

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

    Thank you,

    Dirk


  • 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
    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      If it does not work for you, it's because you don't have any hours for the current week.

      Try clicking on your name and then test as User and find someone who did work this week.