Jump to content
Sign in to follow this  
actionman007

Populating a field based on a date range of two other fields

Recommended Posts

Hi,

I have currently two fields, a start date and an end date. Then I have another field which is an empty field.

What I would like to be able to do is run a calculation that goes along the lines of.

Does 06/04/07 appear in the range of "date1" and "date2" if so put an X into "empty field"

That make sense?

Cheers,

Dan ;)

Share this post


Link to post
Share on other sites

This is the calculation for the 3rd field:

( but you have to have a fourth date field to enter something like "06/04/07" )

Case(

FourthField ≥ start date and FourthField ≤ end date ; "X"

)

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

×

Important Information

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