‎03-06-2019 02:47 PM
Solved! Go to Solution.
‎03-08-2019 05:13 PM
CASE
WHEN IsDate(tblQuickFixEngineering.InstalledOn) = 0
THEN 'no date'
ELSE SUBSTRING(tblQuickFixEngineering.InstalledOn, CHARINDEX('/', tblQuickFixEngineering.InstalledOn, 4)+1, 4) + '-' +
RIGHT('0' + LEFT(tblQuickFixEngineering.InstalledOn, CHARINDEX('/', tblQuickFixEngineering.InstalledOn)-1), 2) + '-' +
RIGHT('0' + SUBSTRING(tblQuickFixEngineering.InstalledOn,
CHARINDEX('/', tblQuickFixEngineering.InstalledOn)+1,
CHARINDEX('/', tblQuickFixEngineering.InstalledOn, 4) - CHARINDEX('/', tblQuickFixEngineering.InstalledOn) -1
), 2)
END AS InstalledOnDate
‎03-18-2019 04:44 PM
‎03-08-2019 05:13 PM
CASE
WHEN IsDate(tblQuickFixEngineering.InstalledOn) = 0
THEN 'no date'
ELSE SUBSTRING(tblQuickFixEngineering.InstalledOn, CHARINDEX('/', tblQuickFixEngineering.InstalledOn, 4)+1, 4) + '-' +
RIGHT('0' + LEFT(tblQuickFixEngineering.InstalledOn, CHARINDEX('/', tblQuickFixEngineering.InstalledOn)-1), 2) + '-' +
RIGHT('0' + SUBSTRING(tblQuickFixEngineering.InstalledOn,
CHARINDEX('/', tblQuickFixEngineering.InstalledOn)+1,
CHARINDEX('/', tblQuickFixEngineering.InstalledOn, 4) - CHARINDEX('/', tblQuickFixEngineering.InstalledOn) -1
), 2)
END AS InstalledOnDate
‎03-08-2019 09:07 AM
‎03-07-2019 05:24 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now