→ Upcoming Keynote Event - Introducing Lansweeper's 2023 Spring Release: 'Duvel' - Learn More
‎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
Test Drive Lansweeper Yourself. Explore our interactive Demo or sign up for free 14-day trial.
Try Now