Can someone please point me in the right direction for date operators. Like what happens when you substract one date from another, what type of value is returned, etc. I thought I knew this stuff, but... searching in the FM manual and help files turns up nothing.

Thanks.

When you subtract two dates with a result type number you get the number of days between the two dates. -bd

One thing to remember. If you use a calculation field to figure time between dates (add or subtract), remember classify the field as a number. If you class it as a date, Filemaker will try to display the number as a date. Such as the number 2 displayed as a date, I believe will display as 01/06/04.

Just an FYI

[ May 14, 2001: Message edited by: WBlanchard ]