Date substraction

[musicarteca]

I have a date calculation with result type number. I am subtracting todays date to a due date. Get(CurrentDate)-Due Date, but the result is a very large number. I imagine that it has to do something like date to number format, but I don't find the DateToNumber function. I am in FMP7.

[Lee Smith]

It sounds like the result of the calculation is a date, and not a number.

Lee

[comment]

What is in DueDate, and what is the large number you're getting?

[stanley]

I think Lee's probably on the money here. From the original post it sounds like you have the calculation set to produce a numerical result, but the field itself is a date field rather than a calculation field.

-Stanley

[musicarteca]

Yes thank you very much, that was the problem