Jump to content

Claris Engage 2025 - March 25-26 Austin Texas ×

The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

Date Calculation

The Headache

By The Headache
May 13, 2008 in Calculation Engine (Define Fields)

Share

https://fmforums.com/topic/59703-date-calculation/

This topic is 6098 days old. Please don't post here. Open a new topic instead.

Recommended Posts

The Headache

Enthusiast

The Headache

Posted May 13, 2008

Posted May 13, 2008

Hi

Can anyone tell me how to subtract one date field from another and have FM return the number of days that has elapsed?

Thanks!

Grand Master

Fitch

Posted May 13, 2008

Posted May 13, 2008

Date1 - Date2

Anuviel

Proficient

Anuviel

Posted May 13, 2008

Posted May 13, 2008

Also make sure that the result is set to number.

Raybaudi

Grand Master

Raybaudi

Posted May 13, 2008

Posted May 13, 2008

... and that the calculation is UNSTORED if one of the two dates is the today date ( Get ( CurrentDate ) )

The Headache

Enthusiast

The Headache

Posted May 13, 2008

Author

Posted May 13, 2008

Thanks!

The fire has been put out and all are safe.

This topic is 6098 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 account

Sign in

Already have an account? Sign in here.

Sign In Now

Share

https://fmforums.com/topic/59703-date-calculation/

Go to topic listing

×

Browse
- Back
- Our Picks
- Blogs
- Clubs
- FM Events
- Events
- Site Support
  - Back
  - Guidelines
  - Staff
  - Feedback
- Gallery
Forums
Blogs
- Back
- Blogs
- Security Blog
Marketplace
Activity
- Back
- Leaderboard
- Online Users
- Search
- All Activity

×

Create New...

Important Information

By using this site, you agree to our Terms of Use.

I accept