capture

Syndicate content

This can be accomplished by adding a new table to your application and using the snapshot property of a date field.

February 5th, 2009 - 5:02 PM

In the following query:

query={'8'.OAF.'3-13-02'}AND{'8'.OBF.'4-13-02'}

I am asking QuickBase to return me only the events that contain the dates
between 3-13-02 and 4-13-02. Is it possible to ask for the events that contain the dates between 'todays date' and 'todays date+5'?

Yes the way to do this is as follows:

query={'8'.OAF.'Today'}AND{'8'.OBF.'-5%20days%20ago'}

February 5th, 2009 - 5:02 PM

The best way to do this is to flip the problem around on its head.

1) Instead of making the date field a formula field, make it a plain date field.

2) Then remove the choice of "Complete" from your multiple choice "Status" field.

3) Create a formula text field called "Computed Status".

4) Put the following formula into the formula property of the "Computed Status" field.

February 5th, 2009 - 5:02 PM

© 1997-2014 Intuit Inc. All Rights Reserved.

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