添加链接
link管理
链接快照平台
  • 输入网页链接,自动生成快照
  • 标签化管理网页链接

@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

Cond.PNG