how to write a formula if days between dates is in range

Question

Hi-

I am trying to get the queue column to say "signed prior" if the date first signed is within the last year of datetime out or prior to datetime out or if date last signed is within the last year of datetime out or prior to date time out otherwise put what is already in the queue column

example data for question.xlsx

Prometheus · Accepted Answer

@Ksisterhen I created a field called Last Year Date, which is DateTime_Out minus 1 year. Then I used this expression to populate "queue": if ([date first signed]>=[Last Year Date] and [date first signed]<=[DateTime_Out]) or ([date last signed]>=[Last Year Date] and [date last signed]<=[DateTime_Out]) then 'signed prior' else [queue] endif