Hi,

Within a LF form, I am trying to create a formula that captures the year in a date field, but minus 1 year. I will then use this minus-one-year in a different field as a lookup field for reporting years. For example, the user will select a calendar date from field_A, let's say the date they select is 3/1/2023. Then in field_B, which is hidden, the report year would be 2022. I'm thinking the formula for field_B (the report year that is the hidden field) should be simple, like  =RIGHT(field_A,4)-1  or  =YEAR(field_A)-1 , but neither work.

Any ideas greatly appreciated.