Groups > comp.databases.filemaker > #1598

Re: Date Fields

Path	csiph.com!usenet.pasdenom.info!aioe.org!.POSTED!not-for-mail
From	Helpful Harry <HelpfulHarry@BusyWorking.com>
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> (permalink)
References	<54e0b2f8-2010-415e-8106-86ef9a0c0a29@googlegroups.com> <slrnlb1gdr.1np6.t-usenet@ID-685.user.individual.de> <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

Show key headers only | View raw

In article <76651a66-69d3-4c19-bedc-6e644872a89c@googlegroups.com>,
<jiriksova@gmail.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)

Thread

Date Fields jiriksova@gmail.com - 2013-12-17 13:03 -0800
  Re: Date Fields Martin Τrautmann <t-usenet@gmx.net> - 2013-12-17 21:27 +0000
    Re: Date Fields jiriksova@gmail.com - 2013-12-17 15:30 -0800
      Re: Date Fields Helpful Harry <HelpfulHarry@BusyWorking.com> - 2013-12-18 13:11 +1300
        Re: Date Fields jiriksova@gmail.com - 2013-12-17 17:26 -0800
        Re: Date Fields Martin Τrautmann <t-usenet@gmx.net> - 2013-12-18 05:24 +0000
          Re: Date Fields Helpful Harry <HelpfulHarry@BusyWorking.com> - 2013-12-18 19:24 +1300
            Re: Date Fields Martin Τrautmann <t-usenet@gmx.net> - 2013-12-18 06:55 +0000
              Re: Date Fields Helpful Harry <HelpfulHarry@BusyWorking.com> - 2013-12-19 18:48 +1300
                Re: Date Fields Martin Τrautmann <t-usenet@gmx.net> - 2013-12-19 07:16 +0000
                Re: Date Fields Howard Schlossberg <howard@nospam.fmprosolutions.com> - 2013-12-19 09:30 -0800
                Re: Date Fields Martin Τrautmann <t-usenet@gmx.net> - 2013-12-19 18:26 +0000
                Re: Date Fields Howard Schlossberg <howard@nospam.fmprosolutions.com> - 2013-12-19 11:45 -0800
                Re: Date Fields Martin Τrautmann <t-usenet@gmx.net> - 2013-12-19 20:05 +0000

csiph-web