Solution in English
Formula Field Type
Alternate Solution
Learn more
Find duration between two dates Find the length of time between the date a record is created and the date the record's marked complete. Dates ToDays([Actual Finish Date] - ToDate([Date Created])) Take the value in the Date Created field (Date / Time type field) and convert it to a date value. Then subtract that date from the Actual Finish Date. Convert the resulting duration to a number of days. Numeric You must convert the this formula result to days to make it data type numeric.

If your result field type if formula-duration instead try:
[Actual Finish Date] - ToDate([Date Created])
If both dates live in Date type fields you can use a much simpler formula: [Actual Finish Date] - [Start Date] More on this solution...
Find the duration between two date fields of different types Actual Finish is a date field and Actual Start is a workdate field. How can I find the duration between them without getting a type mismatch error? Type Conversion [Actual Finish]-ToDate([Actual Start]) Convert the value in the Actual Start field to a date type value. Then subtract that date from the Actual Finish date Duration     More on this solution...

We're glad you're interested in doing more with Quick Base!

Now we need to make you official before you share apps or manage your account.

Verifying your email lets you share Quick Base with others in your company.

Your work email
Your company
Report Name *
Reports and Charts Panel
Each table has a panel listing its reports and charts, organized in groups.
This report will be listed only for you, in the group Mine.
Only you can see the report in the panel. You can't ever list it for other users. You can still let others open it by sending them links.
Please wait while your new report is saved...
This is a new report
Field label
Column heading override
What does auto mean?
Fields in:

Fields to Extract:

Name for the new table:
Items in the new table are called:

When you bring additional fields into a conversion, Quick Base often finds inconsistencies. For example, say you're converting your Companies column into its own table. One company, Acme Corporation, has offices in New York, Dallas and Portland. So, when you add the City column to the conversion, Quick Base finds three different locations for Acme. A single value in the column you're converting can only match one value in any additional field. Quick Base needs you to clean up the extra cities before it can create your new table. To do so, you have one of two choices:

Read more about converting a column into a table.

Show fields from Show fields from Show fields from a related table