geod Posted May 14, 2001 Share Posted May 14, 2001 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. Link to comment Share on other sites More sharing options...
LiveOak Posted May 14, 2001 Share Posted May 14, 2001 When you subtract two dates with a result type number you get the number of days between the two dates. -bd Link to comment Share on other sites More sharing options...
WBlanchard Posted May 14, 2001 Share Posted May 14, 2001 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 ] Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8405 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now