How do I create a report that shows me only records where my date field "Start Date" is in last week from Saturday to Friday?

Knowledge Base

Our Knowledge Base covers a wide variety of technical topics, from the basic to the complex.

1. In a new report or an existing one, create a custom calculated column. To do so, click on 'Custom columns' in the 'Columns' section. Once you've added all the columns you'd like to display on the report, check off the box next to 'Define a calculated column.'

In the expanded area of this section, set the field 'Type' to 'Checkbox.' Enter the following in the Formula box:
[Start Date] >= FirstDayOfWeek(Today()-Days(7)) and [Start Date] < (FirstDayOfWeek(Today()) - Days(2)) and

2. In the 'Filters' section, click on the right radio button to enable filtering. In the expanded section choose '<Custom Column>' from the "Select a field" drop-down list. Select "is" in the middle field, and enter the value "1" in the text box.

Tags:

36402 reads

Comments

Post new comment

Your name: *

E-mail: *

The content of this field is kept private and will not be shown publicly.

Homepage:

Subject:

Comment: *

Input format

Filtered HTML

Web page addresses and e-mail addresses turn into links automatically.
Allowed HTML tags: <a> <p> <hr> <br> <br /> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <em> <b> <u> <i> <strong> <font> <del> <ins> <sub> <sup> <quote> <blockquote> <pre> <address> <code> <cite> <embed> <object> <param> <strike> <caption> <img> <h1> <h2> <h3> <h4>
You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <c>, <cpp>, <drupal5>, <drupal6>, <java>, <javascript>, <php>, <python>, <ruby>, <xml>. The supported tag styles are: <foo>, [foo].
Images can be added to this post.

Plain Text

Web page addresses and e-mail addresses turn into links automatically.
Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>

More information about formatting options

Word verification: * Type the characters you see in this picture.

(verify using audio)

Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

Knowledge Base