Date Problem

[marra1]

I am trying to calculate the number of days a house has been on the market. I am using this:

CURDATE( ) - listDate

I thought this was working fine until I added records with a list date starting the month prior. for some reason 13 day olds were showing as 83, 14 days were showing 84, and so on. All adding 70 days.

Any help would be greatly appreciated.

[Salsa]

Marra, try TO_DAYS(CURDATE()) - TO_DAYS(listDate)

[marra1]

Thank you Salsa! That did the trick. I really appreciate your help!