Path: csiph.com!usenet.pasdenom.info!aioe.org!.POSTED!not-for-mail From: Helpful Harry Newsgroups: comp.databases.filemaker Subject: Re: Date Fields Date: Wed, 18 Dec 2013 13:11:27 +1300 Organization: Aioe.org NNTP Server Lines: 37 Message-ID: <181220131311275964%HelpfulHarry@BusyWorking.com> References: <54e0b2f8-2010-415e-8106-86ef9a0c0a29@googlegroups.com> <76651a66-69d3-4c19-bedc-6e644872a89c@googlegroups.com> NNTP-Posting-Host: jRYlHf6rC6PbrLEKil4LrQ.user.speranza.aioe.org Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: abuse@aioe.org User-Agent: Thoth/1.5.4 (Carbon/OS X) X-Notice: Filtered by postfilter v. 0.8.2 Xref: csiph.com comp.databases.filemaker:1598 In article <76651a66-69d3-4c19-bedc-6e644872a89c@googlegroups.com>, wrote: > On Tuesday, December 17, 2013 3:27:23 PM UTC-6, Martin Ԥrautmann wrote: > > On Tue, 17 Dec 2013 13:03:33 -0800 (PST), jiriksova@gmail.com wrote: > > > > > > I have two date fields: Project_start_date and Project_finish_date and > > > one calculated field Project_status. Project is either NotStartedYet, > > > InProgress, or Finished. > > > > > > Date fields do not sometime trigger the correct Project Status. For > > > example, a project starts Nov 1, 2013, project finish value is Jun 1, > > > 2014, and today is Dec 17, 2013, but a calculated Project Status shows a > > > value NotStartedYet. But when I copy the value of StartDate field, clear > > > the field, and paste the value back into the field, ProjectStatus value > > > is re-calculated correctly to be InProgress. The finish date sometimes > > > triggers the same behavior. > > > > > > What am I doing wrong? > > > > > > Thanks for any suggestion or advice > > > > Is the status unstored? > > > > Does it calculate on empty fields? > > Status calculation is stored. No status is calculated if either or both > date fields are empty. Calculation Fields that you want to automatically update should always be Unstored. That way Filemaker recalculates it every time the field is used (on-screen, printouts, other calculations, exports, etc.). In most circumstances Stored calculations make no sense (auto-enter and scripted calculations are usually better options for stored results), and FileMaker's default should really be Unstored. Helpful Harry :o)