Dancie

I found the issue. The AllocationDate field was set as "Text" and not "Date". Once I changed it to a "Date" field, it worked fine. Thanks for your patience with me.

I've tried what has been suggested, but it doesn't seem to work the way I'd like. After inserting the formula and tested with an AllocationDate of "10/01/2019" the result is still "4/30/2020". Entries from first ten days of October only calculates a 6 month deadline instead of 12. When entered "10/10/2019" it then calculates a 12 month deadline. Also, regardless of the year entered, the result would calculate 12 months in any dates in October - June 30, but I only want AllocatioDate's in between October 2019 - June 2020 These are my tested results: AllocationDate AwardDeadline Desired End Result 10/01/2019 04/30/2020 10/31/2020 10/01/2018 04/30/2020 04/30/2020 10/10/2018 10/31/2019 04/30/2020 06/15/2020 12/31/2020 06/31/2021 07/01/2020 01/31/2021 07/31/2021 10/15/2020 10/31/2021 04/40/2021

I have an "Award Deadline" field that is calculated based on what is entered into another date field, "Allocation Date". The "Award Deadline" is typically 6 months from the "Allocation Date". Recently, due to COVID-19, "Allocation Date" entries in between October 2019 to June 2020 are allowed 12 months instead of the typical 6. I am trying to fix/revise the Case in my "Award Deadline" field to allow entries of date between October 2019 to June 2020 in the "Allocated Date" field to calculate 12 months. The case I have written for the "Award Deadline" is: Case ( ${Alloc. Date (CON) 1} ≤ GetAsDate("9/30/2019"); Date(Month(${Alloc. Date (CON) 1}) + 7;1; Year(${Alloc. Date (CON) 1})) - 1; ${Alloc. Date (CON) 1} ≥ GetAsDate("07/31/2020"); Date(Month(${Alloc. Date (CON) 1}) + 7;1; Year(${Alloc. Date (CON) 1})) - 1; ${Alloc. Date (CON) 1} ≥ GetAsDate("10/1/2019"); Date(Month(${Alloc. Date (CON) 1}) + 13;1; Year(${Alloc. Date (CON) 1})) - 1; ${Alloc. Date (CON) 1} ≤ GetAsDate("06/30/2020"); Date(Month(${Alloc. Date (CON) 1}) + 13;1; Year(${Alloc. Date (CON) 1})) - 1; Date(Month(${Alloc. Date (CON) 1}) + 7;1; Year(${Alloc. Date (CON) 1})) - 1 ) It of course doesn't work. I am still a beginner in Filemaker and am still learning Calculations. Any suggestions/help would be appreciated.