• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 412
  • Last Modified:

Simple Date Calculation in Filemaker

I need to preform a simple date calculation in Filemaker.  I am new to filemaker and do not know how to accomplish this.  I have two date fields..say Date#1 and Date#2.  I want a third field to display the number of days between Date#1 and Date#2.  I tried to simply say Date#2 - Date#1 =, but it didn't work.

Thanks
0
VTE_TECH
Asked:
VTE_TECH
  • 7
  • 6
1 Solution
 
lesouefCommented:
make the result to be a number field, not a date.
0
 
VTE_TECHAuthor Commented:
The result field is set to number.
0
 
lesouefCommented:
?? and are date1 and date2 date fields? or text fields?
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
VTE_TECHAuthor Commented:
Sorry for the confusion.  Let me be more presice.  I am working with a simple DB for Real Estate Listings.  The first Date is "List Date" (set to date field), The second Date is "Sold Date" (set to date field), the result field is "Days on Market" (set to number field).  The result (or DOM) is the number of days between the two dates.  Hope this helps clairify.

Thanks
0
 
lesouefCommented:
there was no confusion, all OK. so that should work...
I can't see where you can be wrong with this so far. Can you post the file?
0
 
VTE_TECHAuthor Commented:
I couldn't upload the DB file (file extension not accepted).  Attached are some screenshots of the Preview & field properties.  Thanks.
DB-Screenshots.pdf
0
 
VTE_TECHAuthor Commented:
I just realized that I could zip the file & attach.  Do you still need the file?  Thanks
0
 
lesouefCommented:
you can use:
http://www.ee-stuff.com/accessLogin.php?returnURL=%2FExpert%2FUpload%2Fupload.php
or mine
http://pagetruck.com where you need my mail s [at] lesouef [dot] com
or direct email if not too big
0
 
VTE_TECHAuthor Commented:
Ok.  Uploaded it on EE Stuff...Here's the link:
https://filedb.experts-exchange.com/incoming/ee-stuff/7611-RC_Listings.fp7

Thanks!




0
 
lesouefCommented:
you left the "do not replace existing value for field" flag set in the field / auto-enter / calculated value settings, so it prevents the value to update. Use this flag when you wanna keep the original value.
0
 
VTE_TECHAuthor Commented:
Problem Solved.  Thanks for your help Lesouef!
0
 
VTE_TECHAuthor Commented:
THANKS!  PROBLEM SOLVED!
0
 
lesouefCommented:
:-)
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 7
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now