Hello everyone,
I’m struggling creating a formula.
I have created 2 date fields:
Employment Start Date, Employment Finish Date and addicionaly there are 3 fields (checkbox)
Employment sustained 3 Months
Employment sustained 6 Months
Employment sustained 12 Months
If the difference between Employment Finish date and Start date is greater than 3 months so the checkbox Employment sustained 3 Months must be checked equally for 6 and 12 months.
Addicionally, if the Employment finish date is blank and the difference between today’s date and start date is greater than 3 then the Employment sustained 3 Months must be checked.
I don’t know how to add all this conditions in a formula.
Could you help me please?
thanks in advance

Hello everyone,
I’m struggling creating a formula.
I have created 2 date fields:
Employment Start Date, Employment Finish Date and addicionaly there are 3 fields (checkbox)
Employment sustained 3 Months
Employment sustained 6 Months
Employment sustained 12 Months
If the difference between Employment Finish date and Start date is greater than 3 months so the checkbox Employment sustained 3 Months must be checked equally for 6 and 12 months.
Addicionally, if the Employment finish date is blank and the difference between today’s date and start date is greater than 3 then the Employment sustained 3 Months must be checked.
I don’t know how to add all this conditions in a formula.
Could you help me please?
thanks in advance