Skip to Navigation

Knowledge Base

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

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?

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.


How to modify invoice reports

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

Hello,As QuickBase is


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 A member of our team would be happy to help!



Post new comment

The content of this field is kept private and will not be shown publicly.
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.

© 2016 QuickBase, Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit