‎05-20-2022 01:34 AM
Case
When IsDate(tblAssets.LastLsAgent) = 1 And IsDate(tblAssets.LastActiveScan)
= 0 Then tblAssets.LastLsAgent
When IsDate(tblAssets.LastActiveScan) = 1 And IsDate(tblAssets.LastLsAgent)
= 0 Then tblAssets.LastActiveScan
When tblAssets.LastLsAgent > tblAssets.LastActiveScan Then
tblAssets.LastLsAgent
When tblAssets.LastActiveScan > tblAssets.LastLsAgent Then
tblAssets.LastActiveScan
Else ''
End As [Last Scan Date]
‎05-31-2022 08:01 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now