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
Solved! Go to Solution.
@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