time

Syndicate content

If your boss is like my boss, she wants to know what I accomplished this week, what I accomplished last week, and what I plan to accomplish next week. Building Reports in QuickBase to help you manage this reporting requirement can be a little tricky, but with some well-built formula fields in your data table, you can get it done.

February 5th, 2009 - 6:02 PM

To achieve the results you are asking about, you will need to do the following:

1) Create a Zip Codes Table where each record is a Zip Code that will be assigned to your projects.
2) In the Zip Codes table, designate a Zip Code (text) field as the key field. (Normally Record ID#)

February 5th, 2009 - 6:02 PM

Let's assume the Date field is called "My Date" and that the Time of Day field is called "My Time of Day". Let's also assume that you want the display format to be:

08-17-2001 01:01:01

Then the text formula to display the date and the timestamp fields together in one cell would be:

[My Date] & " " &

Right("0" & Hour([My Time of Day]), 2)

& ":" &

February 5th, 2009 - 6:02 PM

A specific report subscription is always emailed at the same time of day (or time of week). However, this time is chosen at random when the report subscription is created.

Currently, the time is randomly chosen in the range from 08:00 to 15:00 UTC time. Depending on daylight savings, this translates into:
Eastern Time: 3AM to 11AM
Pacific Time: 12AM to 8AM

February 5th, 2009 - 6:02 PM

QuickBase has usually less than 8 hours per year downtime for scheduled maintenance. This breaks down to about 5-20 minutes a month, typically. Our service page denotes any current service interruptions as well as a history of last month's service status.

http://service.quickbase.com

February 5th, 2009 - 6:02 PM

© 1997-2014 Intuit Inc. All Rights Reserved.

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