asked on

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

Member_2_908359

make the result to be a number field, not a date.

VTE_TECH

ASKER

The result field is set to number.

Member_2_908359

?? and are date1 and date2 date fields? or text fields?

VTE_TECH

ASKER

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

Member_2_908359

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?

VTE_TECH

ASKER

I couldn't upload the DB file (file extension not accepted). Attached are some screenshots of the Preview & field properties. Thanks.
DB-Screenshots.pdf

VTE_TECH

ASKER

I just realized that I could zip the file & attach. Do you still need the file? Thanks

Member_2_908359

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

VTE_TECH

ASKER

Ok. Uploaded it on EE Stuff...Here's the link:
https://filedb.experts-exchange.com/incoming/ee-stuff/7611-RC_Listings.fp7

Thanks!

ASKER CERTIFIED SOLUTION

Member_2_908359

membership

This solution is only available to members.