2 Replies Latest reply on Sep 3, 2009 4:31 PM by imgaryshap

    Date Symbols and Variables in a field

    imgaryshap

      Title

      Date Symbols and Variables in a field

      Post

      Hello, I'm new to Filemaker Pro.  I'm using version 8.0.

       

      I know that if I add the Date Symbol "//" to the layout, it will give me the current date (a variable) every time I check a record.

       

      How do I use that for a field or calculation?

       

      For example - I'm trying to keep track of a product, and want to know how long it takes to get a response.   I need a variable date (today's date) - the static date.  

       

      Anyone?

       

      thanks so much.

       

      -G. 

        • 1. Re: Date Symbols and Variables in a field
          philmodjunk
            

          You can treat date fields as special number fields that count the number of days that have elapsed since some arbitrary very early date. Thus, you can easily use them in calculations and get answers that are either dates or a number of days depending on the calculation.

           

          In your  case, datefield1 - datefield2 will return the number of days between the dates stored in the two fields.

           

          Use this expression to get the number of days it took to get a response:

           

          get ( currentdate ) - yourtable :: yourDateField.

           

          If you define this in a calculation field, make it an unstored calculation so that it always recalculates with each new day.

          • 2. Re: Date Symbols and Variables in a field
            imgaryshap
              

            Thanks so much.   You went above and beyond answering my question.  It turns out that what I really needed to do was as simple as Get (Current Date), but to mark it as "unstored."

             

            Thanks again!