weststreet Posted April 19, 2006 Share Posted April 19, 2006 I have three fields... 1) date_due_in 2) date_actually_received 3) days_difference I want to calculate the difference between field 1 and 2, and return a number (number of days) into field 3. It's amazing how much time I waste when I don't know what I'm doing! MW Link to comment Share on other sites More sharing options...
IdealData Posted April 19, 2006 Share Posted April 19, 2006 You're gonna kick yourself when you see this... Make days_difference to be a calculation (number) with the following formula: date_actually_received - date_due_in (the date fields need to be defined as type DATE. Yes, FileMaker supports basic maths on non-numeric data types, in this instance dates, but so intuitive. Link to comment Share on other sites More sharing options...
weststreet Posted April 19, 2006 Author Share Posted April 19, 2006 That was too easy! Sometimes I over think these things. It works like a charm. Thanks! MW Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6582 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