Jump to content

Claris Engage 2025 - March 25-26 Austin Texas ×

calculation

IEW

By IEW
August 24, 2005 in Layouts

Share

https://fmforums.com/topic/36292-calculation/

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

Recommended Posts

IEW

Community Regular

IEW

Posted August 24, 2005

Posted August 24, 2005

Find number of days between two dates. (Got it)

If days are greater that 15:

Change color of 15 and greater to red.

Can this be done in one calculation?

IW

sbg2

Proficient

sbg2

Posted August 26, 2005

Posted August 26, 2005

Let([x = Date2 - Date1; y = If(x < 15; x ; TextColor (x ; RGB ( 255 ; 0 ; 0 )))]; y)

This topic is 7030 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/36292-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