Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.filemaker > #1597

Re: Date Fields

Show all headers | View raw

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.

Back to comp.databases.filemaker | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

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