How do I create a report that shows me only records where my date field "Start Date" is equal to or greater than the first day of this month?

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, make sure that 'Custom columns' is selected in the 'Columns' section. Once you've added the normal columns you'd like to appear on the report, check off the box next to 'Define a calculated column.'

Set the field 'Type' to 'Duration,' and enter the following in the Formula box:

[Start Date] - FirstDayOfMonth(Today())

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

Tags:

36808 reads

Comments

How to modify invoice reports

Submitted by Anonymous (not verified) on Mon, 05/21/2012 - 01:41.

How to modify invoice reports to show taxable amount against each invoice

Hello,As QuickBase is

Submitted by qb_support_Phil on Sat, 06/30/2012 - 08:22.

Hello,

As QuickBase is extremely customizable, the answer to this question would most likely be specific to your environment. If you would like to discuss your requirements further, please feel free to contact our support team at https://quickbase.intuit.com/support/portal/. A member of our team would be happy to help!

Best,

Phil

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