• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 416
  • 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
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

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