Help with Value List to Add Days to a textbox

[Maria Tique]

I have a HireDate field for each employee.

I have a Pay Class field structured as a Pop up Menu with the following list values:

1. A03

2. A01

3. A06

4. Facility

I also have 6 textboxes named the following:

1. Review Dates 1

2. Review Dates 2

3. Review Dates 3

4. Facility Reap

5. Facility P& T

6. Annual Review

Note: Review Dates 1, 2, 3 are date fields.

Question:

Please help!! How do I do this?

If user clicks on A03 then Review Dates 1 field should be hiredate + 35 days

and Review Dates 2 field should be hireDate + 70 days

and Review Dates 3 field should be hireDate + 90 days note: results should be in date format

If user clicks on A01 or A06 then Review Dates 1 field should be HireDate + 90 days

And Review Dates 2 field should be HireDate + 180 days Notes: Results should be in date format

If user clicks on Facility then it will populate Facility Reap field with text of “March” and Facility P& T field with text of “June” and Annual Review with text of “December”

[sbg2]

From the information you have provided it appears your "6 textboxes" should be calculations, for example:

Review Dates 1 (Unstored, calculation result is Date) = Case(Pay Class = "A03"; Hire Date + 35; Pay Class = "A01" or Pay Class = "A06"; Hire Date + 90)

Facility Reap (Unstored, calculation result is Text) = If(Pay Class = "Facility"; "March")

[Maria Tique]

Yes it worked. Thank you so so so so much.