merkaba22 Posted September 21, 2006 Share Posted September 21, 2006 In order to create calc for a second date 10 days earlier than a entered date in "date1", 9/20/2006, for example: "date2" = ( DayOfYear ( date1 ) -10 ) as a "number" yields the value "253" In a new calc "date3", the value "253" returned as a date yields 9/10/0001. I see that the day and month are correct but the year is off. What am I missing? Link to comment Share on other sites More sharing options...
Lee Smith Posted September 21, 2006 Share Posted September 21, 2006 FileMaker stores dates as numbers starting with 1/1/0001, so a answer of 253 is equal to the 253rd day of year 1 All you need to do is to subtract 10 for your date (or add 10) and you will get the result. c_date2 (calculation, date result) = date1 -10 a date result will equal 9/10/2006 if the field contents of date1 is 9/20/2006 HTH Lee Link to comment Share on other sites More sharing options...
merkaba22 Posted September 21, 2006 Author Share Posted September 21, 2006 Perfect -- that was so easy -- thank you:) Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6519 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