Date range comparison and results

[RanDad]

I have two fields, Entry Date and Pay Period. When a date is entered in the Entry Date, I want it to look at a specific range of dates in a value list and decide which Pay Period it belongs in. (Is using a value list the best way?)

Here is an example Entry Date: 1/20/2001

Here is an example of the value list:

1/1/2001

1/14/2001

1/27/2001

Here is the result I expect to see in the Pay Period field: 1/14/2001

I'm using FMP 5 server for both Windows and Macintosh users.

Thanks for any help......

[LiveOak]

In English, give an Entry date, how do you determine the pay period (next Friday, etc.)?

-bd

[RanDad]

quote:

---

Originally posted by LiveOak:

In English, give an Entry date, how do you determine the pay period (next Friday, etc.)?

-bd

---

Yes, that's what I want to do.