12 Replies Latest reply on Jun 24, 2010 9:47 AM by tonifromkansas

# Calculating How Many Days On The Market

### Title

Calculating How Many Days On The Market

### Post

Help, I am brand new to Filemaker Pro 11 Advanced, using Mac OS X version 10.6.2.  I built a database of properties along with the days they were put on the market, but I can't get a simple calculation to show exactly how many days each one has been on the market. The dates are all in one column titled Days In Inventory and they need to be subtotaled by days on the market by property ID number.  Any help is greatly appreciated!

• ###### 1. Re: Calculating How Many Days On The Market

This Unstored calculation will show elapsed days: Get ( CurrentDate ) - DateListed

Where date listed is the date field where you recorded the date the property was placed on the market.

• ###### 2. Re: Calculating How Many Days On The Market

THANK YOU!  This was driving me crazy!

• ###### 3. Re: Calculating How Many Days On The Market

That works great, but also how would I get not just through today's date, but the last date listed on the market?  For example, 12/17/2009 through 3/31/2010 - how would I get just those dates, not just through today's date?

• ###### 4. Re: Calculating How Many Days On The Market

Are both fields defined in the same record? Is this "last date" field empty if it's still listed on the market?

If so, you can do something like this:

If ( IsEmpty (LastDate) ; Get ( CurrentDate ) - DateListed ; LastDate - DateListed )

Where LastDate is the last date the property was listed on the market.

Given that the expression still uses Get ( CurrentDate ) you'll still need to set this up as an unstored calculation.

• ###### 5. Re: Calculating How Many Days On The Market

Get ( CurrentDate ) - DateListed

Perhaps along the lines of :

Case (

isempty( LastDateListed ) ; Get ( CurrentDate ) - DateListed ;

LastDateListed - DateListed

)

This will show how many days the property has been on the market to date (if its not sold)

or if its no longer on the market (last date listed) will show how many days it WAS on for.

• ###### 6. Re: Calculating How Many Days On The Market

I think the problem is the way it was imported, which I didn't have control of.  Date Listed is all in one column for each property ID #, so when it first went on the market 12/2/09, that calculates to 201 days. Since it is still on the market, as of 5/14/10, the calculation returns it as 38 days on the market. I put the results in a new column Days On Market next to the Date Listed column.

'

• ###### 7. Re: Calculating How Many Days On The Market

I don't follow that. How can you tell from the data whether a given property is still on the market or not?

• ###### 8. Re: Calculating How Many Days On The Market

I was supplied with a huge list of  properties by month that were/are still on the market.  From 9 PDF files by month, of all things. They then highlighted if it sold in yellow. I assume this was all originally done in Word format. Crazy.  I had to convert from PDF to Excel then to Filemaker.

• ###### 9. Re: Calculating How Many Days On The Market

Ok, but in your database, how are you indicating that a property is no longer listed? Do you have a field that says "Sold"? A date sold field? or what? You have to have field that records the sale or de-listing date or there's no way to set up a calculation for days on the market that can give you the correct figure for properties that have been sold or de-listed.

• ###### 10. Re: Calculating How Many Days On The Market

Yes, I have a separate column set up that will state "Sold" and the date.

• ###### 11. Re: Calculating How Many Days On The Market

SWS and I posted very similar solutions that will work then.