DATE subtract in FM

[JPCogAdmin]

Hi,

I wonder if any of you have an answer that can help. Here is the scenario.

I have a table that has 2 dates (date1 and date2). To get the amount of days I created a query item that is composed of this (day2 - day1). Now I'd like to convert this into a number value. However, I've tried using cast and it fails. I'm using FrameWork Mgr 8. Does someone know how to do this?

-j

 

[blom0344]

Probably because subtracting a date from a date yields a numeric value in the first place..

Ties Blom